Microsoft Access as Frontend for DB2

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dirk Deimeke - 30 Nov 2004 10:13 GMT

Hello,

I am searching documentation (Redbooks, White Papers, ...) about using DB2
as a backend for Microsoft Access.

Can anybody help me?

Thanks a lot

Dirk

Reply to this Message

Christos Kalantzis - 30 Nov 2004 13:11 GMT

Make sure you register your DB2 database as a system DSN (ODBC) on the
machine that will be running Access. Then from Access choose get
external data, and choose either import table or link to table.

That works for me, so it should work for you.

CHristos Kalantzis

> Hello,
>
[quoted text clipped - 6 lines]
>
> Dirk

Reply to this Message

Dirk Deimeke - 30 Nov 2004 14:00 GMT

Christos Kalantzis:

> Make sure you register your DB2 database as a system DSN (ODBC) on the
> machine that will be running Access. Then from Access choose get
> external data, and choose either import table or link to table.

Which driver did you install on the Windows workstations?

> That works for me, so it should work for you.

Thanks a lot.

Dirk

Reply to this Message

Christos Kalantzis - 30 Nov 2004 15:16 GMT

For ODBC, you have to install the db2 client (Someone please correct me
if you can get away with at least the run-time client).

Once installed, you have to catalog the target database. The client
configuration assistant is great if you don't have enough experience in
catalogging databases...as well it will create the ODBC DSN for you.

Hope this helps

Christos Kalantzis

> Christos Kalantzis:
>
[quoted text clipped - 9 lines]
>
> Dirk

Reply to this Message

Dirk Deimeke - 30 Nov 2004 16:02 GMT

Christos Kalantzis:

> For ODBC, you have to install the db2 client (Someone please correct me
> if you can get away with at least the run-time client).

I see there is a "DB2 Run-Time Client Lite" which contains ODBC-Drivers.

> Once installed, you have to catalog the target database. The client
> configuration assistant is great if you don't have enough experience in
> catalogging databases...as well it will create the ODBC DSN for you.

Ok, thank you.

Cataloging will be no problem, but DSNs are new to me.

Thanks for your support.

Dirk

Reply to this Message