| Sue Hoegemeier 2006-02-15, 3:23 am |
| 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"
<x@y.com> wrote:
>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;
>
|