[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.odbcnet

ODBC timeout on long queries

Paul

8/30/2002 4:17:00 PM

I'm using the ODBC ADO.NET library to access a Sybase
database to access a long-running query for an ASP.NET
page. I set the ConnectionTimeout to 0, but it's still
reporting a timeout error. Can someone provide a hint on
how to set the timeout correctly?

Many thanks,
Paul
1 Answer

(Hussein Abuthuraya(MSFT))

8/30/2002 7:54:00 PM

0

Paul,

The Connection Timeout property is used to set the time that a connection maybe created within. To run long-running queries, you need to set the Command Timeout
property to a value higher than 30 seconds which is the default. You may specify this value to be zero and in this case the query never times out.

Check the ODBC Documentation (located at C:\Program Files\Microsoft.NET\Odbc.Net\Odbcref.chm) for further information.


Thanks,
Hussein Abuthuraya
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.co....