What is Client Access ODBC Driver ?

[pwing]

Hi All,
I know there is a middleware called Client Access Express V5.2, DB2 Connect 8.1, etc. But, have not heard or used Client Access ODBC Driver 8.0. Is this the same as DB2Connect 8.0 ??

Any help appreciated.

P

 

[SkiLift]

Client Access ODBC Driver allows you to connect to your DB2 database from your PC. For example, you can write your own software that connects to it, or you can connect to it and import DB2 tables into MS EXCEL and ACCESS. Open Excel help and type in 'odbc'.

I dont know what DB2Connect is.

If you have Client Access Express then I think you have the Driver. Go to 'Start | Programs | IBM Client Access Express | ODBC Administration' and you should see the driver in the 'user dsn' or the 'system dsn' tab.

 

[pwing]

Thanks.
So is

Client Access ODBC = Client Access Express?

Are these the same IBM DB2 middleware product, but just a different name?

thank.
P

 

[blom0344]

Client Access Express is preferred for creating ODBC connections to AS400 filesystems. The entire package falls under license, but if you just install the ODBC components it is free of charge.

Earlier versions are called Client Access, the 'express' part came with the latest 4 versions.

Connecting to DB2 UDB is possible with the run-time client ODBC components. You get a nice client configuration assistant that lets you set up database connections very elegantly.

My experience is , that using Access on DB2 tables requires you to configure the DSN to automatically log on to the database. Strangely enough Excel works properly with prompted logon...

T. Blom
Information analyst
tbl@shimano-eu.com