Problems connecting to SQLHost using ODBC

[Alex Polonetskiy]

 Posted by:  Alex Polonetskiy <apol...@csc.com> 

I had a problem attempting to connect to DB2 via SQLHost using the ODBC
driver. When attempting to connect, I get the following error:


DB2 994 Connecting with multiple cursors is invalid with autocommit
Driver's SQLSetConnectAttr failed.

I can connect to SQLHost directly through Gupta connectivity (with SQLTalk),
but cannot connect through ODBC using MSAccess or MSQuery.

If anyone has come across this problem and knows what the problem is, I
would appreciate a response.

Thanks,
Alex Polonetskiy
apol...@csc.com

[Peter Grundler]

 Posted by:  peter.g...@intrasys.co.at (Peter Grundler) 

Hi Alex,


If you use MSAccess97: has you updated your software with the
SR1-patch?

ciao,
Peter