Page 1 of 1
Working with a DB2 64bit from a 32 Bit Windows
Posted: Mon 19 Oct 2009 14:28
by skippy
Hi,
is it possible to use a DB2 Server 64Bit (Linux) from a 32Bit ODBC from 32Bit Windows ?
Thx & Rgds
Posted: Tue 20 Oct 2009 07:23
by Plash
We have not tested this situation. I think, it is possible.
Posted: Tue 20 Oct 2009 11:38
by skippy
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
Posted: Wed 21 Oct 2009 11:38
by Plash
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.
Posted: Wed 21 Oct 2009 14:03
by skippy
OK thanks. Can you suggest any client installation to use without that overhead I had ? (348 MB)
Posted: Thu 22 Oct 2009 08:55
by Plash
You can install DB2 Runtime Client. It requires maximum 100 MB if you install all features.