By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,678 Members | 2,439 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,678 IT Pros & Developers. It's quick & easy.

ODBC question

P: n/a
I am trying to connect to a DB2 v7.2 database from Lotus 123 v9.8
on a Windows XP Pro machine. I have the Software Development Client
installed on the XP machine and have run the Client Configuration
Assistant and registered the SAMPLE and my TEST databases with the
ODBC Administrator as System DSN data sources. Everything seems
fine, but when I try to connect to "External Tables" through 123
my DB2 databases are not listed under available ODBC_data_sources.

The same setup works fine under WIN9x. Is there some sort of ODBC
version difference between DB2 7.2 and Windows XP?

Any help appreciated.

Thanks,
Philip Wright
pv*****@attglobal.net

Nov 12 '05 #1
Share this Question
Share on Google+
8 Replies


P: n/a

Originally posted by Philip Wright
I am trying to connect to a DB2 v7.2 database from Lotus 123 v9.8 on a Windows XP Pro machine. I have the Software Development Client installed on the XP machine and have run the Client Configuration Assistant and registered the SAMPLE and my TEST databases with the ODBC Administrator as System DSN data sources. Everything seems fine, but when I try to connect to "External Tables" through 123 my DB2 databases are not listed under available ODBC_data_sources. The same setup works fine under WIN9x. Is there some sort of ODBC version difference between DB2 7.2 and Windows XP? Any help appreciated. Thanks, Philip Wright pv*****@attglobal.net


Philip,

did you create a system DSN or a user DSN ?

marcos oliva
--
Posted via http://dbforums.com
Nov 12 '05 #2

P: n/a
> Originally posted by Philip Wright

I am trying to connect to a DB2 v7.2 database from Lotus 123 v9.8


on a Windows XP Pro machine. I have the Software Development Client


installed on the XP machine and have run the Client Configuration


Assistant and registered the SAMPLE and my TEST databases with the


ODBC Administrator as System DSN data sources. Everything seems


fine, but when I try to connect to "External Tables" through 123


my DB2 databases are not listed under available ODBC_data_sources.

The same setup works fine under WIN9x. Is there some sort of ODBC


version difference between DB2 7.2 and Windows XP?

Any help appreciated.

Thanks,


Philip Wright


pv*****@attglobal.net



Philip,

did you create a system DSN or a user DSN ?

marcos oliva


System DSN.

Thanks,
Philip

Nov 12 '05 #3

P: n/a
XP client can communicate with DB2 7.2 (we have this running in production).

Just so we can narrow this down:
1) What happens if you use Microsoft Excel?
2) What happens if you use the MS OLE DB over ODBC instead of ODBC (caveat:
I don't know Lotus any more)?
3) What's your DB2 server (platform and version)? You only said you had the
Software Development Client 7.2 on XP?
4) What fixpacks have you applied to client and server?

"Philip Wright" <pv*****@attglobal.net> wrote in message
news:9m*******************@newsread1.news.atl.eart hlink.net...
I am trying to connect to a DB2 v7.2 database from Lotus 123 v9.8
on a Windows XP Pro machine. I have the Software Development Client
installed on the XP machine and have run the Client Configuration
Assistant and registered the SAMPLE and my TEST databases with the
ODBC Administrator as System DSN data sources. Everything seems
fine, but when I try to connect to "External Tables" through 123
my DB2 databases are not listed under available ODBC_data_sources.

The same setup works fine under WIN9x. Is there some sort of ODBC
version difference between DB2 7.2 and Windows XP?

Any help appreciated.

Thanks,
Philip Wright
pv*****@attglobal.net

Nov 12 '05 #4

P: n/a
Hi Mark,

Thanks for your response. The XP client (SDK 7.2.8) is working just
fine. The problem that I am having is that Lotus 123 doesn't see the
DB2 ODBC driver in it's list of external database drivers. When I
run the Client Configuration Assistant on a WIN98 machine it makes
the DB2 ODBC driver available to 123 (and all other apps). It isn't
doing this on Win XP Pro.

To answer your questions:
1) We don't (and won't) have Excel.
2) What do you mean by MS OLE DB?
3) The server is DB2 7.2.8 on OS/2 4.52 (all WIN98 machines with 123
see it just fine).
4) Server and all clients are at 7.2.8

Thanks for your help.

Philip Wright
Mark Yudkin wrote:
XP client can communicate with DB2 7.2 (we have this running in production).

Just so we can narrow this down:
1) What happens if you use Microsoft Excel?
2) What happens if you use the MS OLE DB over ODBC instead of ODBC (caveat:
I don't know Lotus any more)?
3) What's your DB2 server (platform and version)? You only said you had the
Software Development Client 7.2 on XP?
4) What fixpacks have you applied to client and server?

"Philip Wright" <pv*****@attglobal.net> wrote in message
news:9m*******************@newsread1.news.atl.eart hlink.net...
I am trying to connect to a DB2 v7.2 database from Lotus 123 v9.8
on a Windows XP Pro machine. I have the Software Development Client
installed on the XP machine and have run the Client Configuration
Assistant and registered the SAMPLE and my TEST databases with the
ODBC Administrator as System DSN data sources. Everything seems
fine, but when I try to connect to "External Tables" through 123
my DB2 databases are not listed under available ODBC_data_sources.

The same setup works fine under WIN9x. Is there some sort of ODBC
version difference between DB2 7.2 and Windows XP?

Any help appreciated.

Thanks,
Philip Wright
pv*****@attglobal.net



Nov 12 '05 #5

P: n/a
Get yourself a copy of some (other) DB-enabled application. You need to
narrow down whether this is 1-2-3 or not. Excel is the obvious choice as its
database access is known to work.

I also strongly recommend you read up on the topic of OLE DB and ADO so as
to understand how database access works. Although it is feasible that 1-2-3
uses native ODBC calls for database connectivity (as I said, I don't know
1-2-3 any more; we threw it out after Lotus corporation annoyed us), it is
more likely that it uses ADO. Way way back, when Lotus was first released
for OS/2, there was a special add-in package that you needed to enable Lotus
to use DB2. Perhaps this is still the case?

"Philip Wright" <pv*****@attglobal.net> wrote in message
news:3f********@news1.prserv.net...
Hi Mark,

Thanks for your response. The XP client (SDK 7.2.8) is working just
fine. The problem that I am having is that Lotus 123 doesn't see the
DB2 ODBC driver in it's list of external database drivers. When I
run the Client Configuration Assistant on a WIN98 machine it makes
the DB2 ODBC driver available to 123 (and all other apps). It isn't
doing this on Win XP Pro.

To answer your questions:
1) We don't (and won't) have Excel.
2) What do you mean by MS OLE DB?
3) The server is DB2 7.2.8 on OS/2 4.52 (all WIN98 machines with 123
see it just fine).
4) Server and all clients are at 7.2.8

Thanks for your help.

Philip Wright
Mark Yudkin wrote:
XP client can communicate with DB2 7.2 (we have this running in production).
Just so we can narrow this down:
1) What happens if you use Microsoft Excel?
2) What happens if you use the MS OLE DB over ODBC instead of ODBC (caveat: I don't know Lotus any more)?
3) What's your DB2 server (platform and version)? You only said you had the Software Development Client 7.2 on XP?
4) What fixpacks have you applied to client and server?

"Philip Wright" <pv*****@attglobal.net> wrote in message
news:9m*******************@newsread1.news.atl.eart hlink.net...
I am trying to connect to a DB2 v7.2 database from Lotus 123 v9.8
on a Windows XP Pro machine. I have the Software Development Client
installed on the XP machine and have run the Client Configuration
Assistant and registered the SAMPLE and my TEST databases with the
ODBC Administrator as System DSN data sources. Everything seems
fine, but when I try to connect to "External Tables" through 123
my DB2 databases are not listed under available ODBC_data_sources.

The same setup works fine under WIN9x. Is there some sort of ODBC
version difference between DB2 7.2 and Windows XP?

Any help appreciated.

Thanks,
Philip Wright
pv*****@attglobal.net


Nov 12 '05 #6

P: n/a
Approach sees the databases just fine so it seems to be 123. We are not
trying to see the databases from 123 for OS/2. We are trying to upgrade
from WIN98 clients (where everything works just fine) to XP clients and
can't get 123 (same version as on WIN98) to see the DB2 ODBC drivers. It
seems to be a 123 issue and as you don't know 123 I'm not sure that you
can help us - but thanks for trying.

Philip Wright
Mark Yudkin wrote:
Get yourself a copy of some (other) DB-enabled application. You need to
narrow down whether this is 1-2-3 or not. Excel is the obvious choice as its
database access is known to work.

I also strongly recommend you read up on the topic of OLE DB and ADO so as
to understand how database access works. Although it is feasible that 1-2-3
uses native ODBC calls for database connectivity (as I said, I don't know
1-2-3 any more; we threw it out after Lotus corporation annoyed us), it is
more likely that it uses ADO. Way way back, when Lotus was first released
for OS/2, there was a special add-in package that you needed to enable Lotus
to use DB2. Perhaps this is still the case?

"Philip Wright" <pv*****@attglobal.net> wrote in message
news:3f********@news1.prserv.net...
Hi Mark,

Thanks for your response. The XP client (SDK 7.2.8) is working just
fine. The problem that I am having is that Lotus 123 doesn't see the
DB2 ODBC driver in it's list of external database drivers. When I
run the Client Configuration Assistant on a WIN98 machine it makes
the DB2 ODBC driver available to 123 (and all other apps). It isn't
doing this on Win XP Pro.

To answer your questions:
1) We don't (and won't) have Excel.
2) What do you mean by MS OLE DB?
3) The server is DB2 7.2.8 on OS/2 4.52 (all WIN98 machines with 123
see it just fine).
4) Server and all clients are at 7.2.8

Thanks for your help.

Philip Wright
Mark Yudkin wrote:
XP client can communicate with DB2 7.2 (we have this running in
production).
Just so we can narrow this down:
1) What happens if you use Microsoft Excel?
2) What happens if you use the MS OLE DB over ODBC instead of ODBC
(caveat:
I don't know Lotus any more)?
3) What's your DB2 server (platform and version)? You only said you had
the
Software Development Client 7.2 on XP?
4) What fixpacks have you applied to client and server?

"Philip Wright" <pv*****@attglobal.net> wrote in message
news:9m*******************@newsread1.news.atl.e arthlink.net...
I am trying to connect to a DB2 v7.2 database from Lotus 123 v9.8
on a Windows XP Pro machine. I have the Software Development Client
installed on the XP machine and have run the Client Configuration
Assistant and registered the SAMPLE and my TEST databases with the
ODBC Administrator as System DSN data sources. Everything seems
fine, but when I try to connect to "External Tables" through 123
my DB2 databases are not listed under available ODBC_data_sources.

The same setup works fine under WIN9x. Is there some sort of ODBC
version difference between DB2 7.2 and Windows XP?

Any help appreciated.

Thanks,
Philip Wright
pv*****@attglobal.net



Nov 12 '05 #7

P: n/a
Since you've narrowed it down to 1-2-3 (works on '98, fails on XP), and
demonstrated that it's not DB2, you would be best off taking the problem to
a 1-2-3 newsgroup; this is the wrong forum.

I would point out that ODBC is compatible between 98 and XP _when_
programmed to the ODBC (setup) API. Many old programs cut corners and simply
went off to the INI files, skipping the API. Such programs will fail on
NT/W2K/XP. If that is the case, you'll need to open a support case with
Lotus.

"Philip Wright" <pv*****@attglobal.net> wrote in message
news:3f********@news1.prserv.net...
Approach sees the databases just fine so it seems to be 123. We are not
trying to see the databases from 123 for OS/2. We are trying to upgrade
from WIN98 clients (where everything works just fine) to XP clients and
can't get 123 (same version as on WIN98) to see the DB2 ODBC drivers. It
seems to be a 123 issue and as you don't know 123 I'm not sure that you
can help us - but thanks for trying.

Philip Wright
Mark Yudkin wrote:
Get yourself a copy of some (other) DB-enabled application. You need to
narrow down whether this is 1-2-3 or not. Excel is the obvious choice as its database access is known to work.

I also strongly recommend you read up on the topic of OLE DB and ADO so as to understand how database access works. Although it is feasible that 1-2-3 uses native ODBC calls for database connectivity (as I said, I don't know 1-2-3 any more; we threw it out after Lotus corporation annoyed us), it is more likely that it uses ADO. Way way back, when Lotus was first released for OS/2, there was a special add-in package that you needed to enable Lotus to use DB2. Perhaps this is still the case?

"Philip Wright" <pv*****@attglobal.net> wrote in message
news:3f********@news1.prserv.net...
Hi Mark,

Thanks for your response. The XP client (SDK 7.2.8) is working just
fine. The problem that I am having is that Lotus 123 doesn't see the
DB2 ODBC driver in it's list of external database drivers. When I
run the Client Configuration Assistant on a WIN98 machine it makes
the DB2 ODBC driver available to 123 (and all other apps). It isn't
doing this on Win XP Pro.

To answer your questions:
1) We don't (and won't) have Excel.
2) What do you mean by MS OLE DB?
3) The server is DB2 7.2.8 on OS/2 4.52 (all WIN98 machines with 123
see it just fine).
4) Server and all clients are at 7.2.8

Thanks for your help.

Philip Wright
Mark Yudkin wrote:

XP client can communicate with DB2 7.2 (we have this running in


production).
Just so we can narrow this down:
1) What happens if you use Microsoft Excel?
2) What happens if you use the MS OLE DB over ODBC instead of ODBC


(caveat:
I don't know Lotus any more)?
3) What's your DB2 server (platform and version)? You only said you had


the
Software Development Client 7.2 on XP?
4) What fixpacks have you applied to client and server?

"Philip Wright" <pv*****@attglobal.net> wrote in message
news:9m*******************@newsread1.news.atl.e arthlink.net...
>I am trying to connect to a DB2 v7.2 database from Lotus 123 v9.8
>on a Windows XP Pro machine. I have the Software Development Client
>installed on the XP machine and have run the Client Configuration
>Assistant and registered the SAMPLE and my TEST databases with the
>ODBC Administrator as System DSN data sources. Everything seems
>fine, but when I try to connect to "External Tables" through 123
>my DB2 databases are not listed under available ODBC_data_sources.
>
>The same setup works fine under WIN9x. Is there some sort of ODBC
>version difference between DB2 7.2 and Windows XP?
>
>Any help appreciated.
>
>Thanks,
>Philip Wright
>pv*****@attglobal.net
>


Nov 12 '05 #8

P: n/a
"Mark Yudkin" <my***********************@nospam.org> wrote in message
news:bn**********@ngspool-d02.news.aol.com...
Since you've narrowed it down to 1-2-3 (works on '98, fails on XP), and
demonstrated that it's not DB2, you would be best off taking the problem to a 1-2-3 newsgroup; this is the wrong forum.

I would point out that ODBC is compatible between 98 and XP _when_
programmed to the ODBC (setup) API. Many old programs cut corners and simply went off to the INI files, skipping the API. Such programs will fail on
NT/W2K/XP. If that is the case, you'll need to open a support case with
Lotus.

I would also check the Lotus website for patches.
Nov 12 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.