Working with a DB2 64bit from a 32 Bit Windows

skippy · Post by **skippy** » Mon 19 Oct 2009 14:28

Hi,

is it possible to use a DB2 Server 64Bit (Linux) from a 32Bit ODBC from 32Bit Windows ?

Thx & Rgds

Plash · Post by **Plash** » Tue 20 Oct 2009 07:23

We have not tested this situation. I think, it is possible.

skippy · Post by **skippy** » Tue 20 Oct 2009 11:38

I just installed DB2 Client only Interfaces, ODBC / JDBC etc.(348 MB !!!)
When I try to connect, I get the error

[IBM][CLIDriver] CLI0124E Ungültiger Wert für ein Argument. SQLSTATE=HY009

The error text above means "Invalid Value for an argument".

Btw, why do I actually need a DB2 Provider, as the connection gows through ODBC anyway ?

Rgds

Plash · Post by **Plash** » Wed 21 Oct 2009 11:38

Have you added the settings for your database to the db2cli.ini file? You should set a database name from this file to the Server property of TUniConnection.

http://publib.boulder.ibm.com/infocente ... 06306.html

DB2 provider has some additional features in comparison with ODBC provider:
- support for the Schema and FuntionPath specific options in TUniConnection;
- the KeySequence specific option in dataset, and support for autoincrement fields.

With DB2 provider you don't need to create ODBC data source or use a connection string.

skippy · Post by **skippy** » Wed 21 Oct 2009 14:03

OK thanks. Can you suggest any client installation to use without that overhead I had ? (348 MB)

Plash · Post by **Plash** » Thu 22 Oct 2009 08:55

You can install DB2 Runtime Client. It requires maximum 100 MB if you install all features.