Timeout error...

Problem

You get a timeout error and want to increase the timeout to run a stored procedure or a query.

Solution

Step 1:  Adjust your application’s run-time execution timeout parameter.  You can specify the executionTimeout attribute in the httpRuntime element in your application’s Web.config file.  The executionTimeout property indicates the maximum number of seconds a request is allowed to execute before being automatically shut down by ASP.NET.  The default is 90 seconds in .NET Framework 1.0 and 1.1 applications; it is 110 seconds in .NET Framework 2.0 applications.

<httpRuntime
            maxRequestLength="10240"
            executionTimeout="90"
/>

For more details see:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpgenref/html/gngrfhttpruntimesection.asp

Step 2:  Set the Microsoft SQL Server Query timeout value if you are using Microsoft SQL Server.  In the Microsoft SQL Server Enterprise Manager, open the SQL Server Properties (properties for the entire server) by right mouse clicking the server node in the tree.  Select the Connection tab and set Query Timeout as desired.  You can set the query timeout to 0 for indefinite or no timeout.

See Also

Part VII:  Troubleshooting Applications

Application Will Not Run

Application Runs But No Data is Displayed

Application Error Messages