ERROR [IM006] [Microsoft][ODBC Driver Manager]

Posted by bablypm on 06-Jun-2013 00:55

I am connecting to Sybase database from a Windows Service (.Net 1.1 ) using ODBC Connection using DataDirect. 

ConnectionString is as follows:

"Driver=DataDirect 4.2 Sybase Wire Protocol;NA=prod,1111;UID=user;PWD=XXXX;DB=MyDB;"

But the it fails with the below error intermittently while establishing a connection.

Failed to open Sybase Connection - ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

This is a live application and is in production for last 7 years without any issues. When this error happens we re-start the windows service and then after that the connection succeeds. The same error happens after some days.

What could be the problem here?

I have latest version of MDAC in my server. Version 2.82

Any help is greatly appreciated.



All Replies

This thread is closed