Re: timeout using SDK 2.81 TC3 - .NET Managed Provider

Apparently, this issue affects the .NET Managed Provider as well as ODBC. The new driver works correctly, but there's been a change in the default behavior. Previously, in SDK 2.7, commands did not time out by default. Now in 2.81 TC3, commands time out after 30 seconds. The big problem with this is that you must explicitly set the command timeout in your code. If you have a large installed base of code already, that's a lot of re-factoring, re-testing, and re-deploying just to upgrade the driver. And there appears to be no way to globally change the default timeout value. If we could set the value to 0 (no timeout), then at least the new driver's basic behavior would match the old one and save us a lot of headache. "Tsutomu Ogiwara" <tsutomu_ogiwara@hotmail.com> wrote in message news:<ci6cjk$gl1$1@news.xmission.com>... > 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