Hi Eric.

Make sure SQL_QUERY_TIMEOUT of SetStmtOption in M$ .NET manual.

I am not Windows familiar, sorry I can say the avobe all.
--
Tsutomu Ogiwara from Tokyo Japan.
ICQ#:168106592





>From: eric@fakeisp.net (-=Eric=-)
>Reply-To: eric@fakeisp.net (-=Eric=-)
>To: informix-list@iiug.org
>Subject: timeout using SDK 2.81 TC3 - .NET Managed Provider
>Date: 13 Sep 2004 19:55:25 -0700
>
>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(Int Ptr
>hHandle, SQL_HANDLE hType, RETCODE retcode)
>at Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObjec t(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.

__________________________________________________ _______________
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail

sending to informix-list