Groups | Blog | Home
all groups > sql server odbc > february 2006 >

sql server odbc : Timeout expired error?


Olav Tollefsen
2/14/2006 5:41:25 PM
I get the below error when I query a SQL Server database from my ASP.NET
application. It looks like the timeout is 30 seconds.

How can I increase the timeout?

Olav

ERROR [HYT00] [Microsoft][ODBC SQL Server Driver]Timeout expired
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.Odbc.OdbcException: ERROR [HYT00]
[Microsoft][ODBC SQL Server Driver]Timeout expired

Source Error:

Line 33: DataSet myDataSet = new DataSet();
Line 34:
Line 35: myDataAdapter.Fill(myDataSet, "Users");
Line 36:
Line 37: DataGrid1.DataSource = myDataSet;

Sue Hoegemeier
2/14/2006 8:03:02 PM
You'd generally want to start by looking at the query and
making sure the query itself is running as efficiently as
possible.
To increase the timeout, look at the CommandTimeout property
of the ODBCCommand Class.

-Sue

On Tue, 14 Feb 2006 17:41:25 +0100, "Olav Tollefsen"
[quoted text, click to view]
AddThis Social Bookmark Button