ODBC question

[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

[Maor71]

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

[Lucille Wright]

> 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

[Mark Yudkin]

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

[Philip Wright]

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

[Mark Yudkin]

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

[Philip Wright]

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

[Mark Yudkin]

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
>

[Mark 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.