Subhash
4/5/2005 5:25:00 AM
Hi, When we stated using odbc on .NET the our standard functional programs
have started reporteing the following errors:
2005-03-01T18:56:19.375 VERBOSE [MainThread.Run] Testing Gaming Floor
Database Connection ...
2005-03-01T18:56:21.096 EXCEPTION [MainThread.Run] Gaming Floor Database
Connection Failed. Retrying in 60 seconds ...
Aristocrat.NX.Shared.Database.DataProviderConnectionTestException: Unable to
Connect to ODBC Database Server, reason: "ERROR [HY000] [Informix][Informix
ODBC Driver][Informix]Cannot attach to transaction.
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr
failed
ERROR [HY000] [Informix][Informix ODBC Driver][Informix]Cannot attach to
transaction." ---> System.Data.Odbc.OdbcException: ERROR [HY000]
[Informix][Informix ODBC Driver][Informix]Cannot attach to transaction.
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr
failed
ERROR [HY000] [Informix][Informix ODBC Driver][Informix]Cannot attach to
transaction.
at System.Data.Odbc.OdbcConnection.Open()
With Connection POOLING Active the error occurs within 18 hours
with Connection POOLING Disabled the error occurs witin say 24 hours.
Any information / suggestions are appreciated.
Also can anyone suggest odbc drivers for connecting to Informix 5.x from
..NET platform.
Regards,
Subhash Parui