timeout using SDK 2.81 TC3 - .NET Managed Provider
Posted in 2004
We have a showstopper issue...after upgrading from SDK 2.7x to 2.81 TC3 (to get the .NET managed provider), we're occasionally running into timeout errors in .NET applications. Specifically, the.NET code is throwing this: Error Message : ERROR [HYT00] [Informix][Informix ODBC Driver]Timeout expired. ERROR [HY008] [Informix][Informix ODBC Driver][Informix]Statement interrupted by user. Stack Trace= at Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode) at Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method) at Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery() at OurCompany.WWWServices.Methodname(XmlNode inputDoc) Source=iclit09b.dll I've been unable to figure out, either in the documentation or on the 'net how to change the default timeout. I think it might be possible within the code, but this is a major problem - we're not about to go revamp our entire codebase. If anyone has seen this or has suggestions, we're all ears. So far, we've tried inserting various things into the connection string, setting the CONTIME and CONRETRY environment variables in SetNet32. Our platform is Informix 9.4O with application servers running Win 2k and Win2k3 server.