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.
Thanks
Bably