Asp.net web application times out on long running stored procedure

kemaltolga — Fri, 25 Jan 2008 02:32:00 GMT

If you are running a web application and you are processing a stored procedure that takes quite a while you might get a time out error. An easy way to fix this is to add "Connect Timeout=60" to your connection string in the web.config file. 60 is in seconds and just an example. Here is an example connection string.

<connectionStrings>

<add name="DatamartConnectionString"

connectionString="Data Source=XXX;Initial Catalog=Datamart;User ID=XXX;Password=XXX; Connect Timeout=60;" providerName="System.Data.SqlClient" />

</connectionStrings>

Good luck

--tolga--

Tolga Koseoglu : Asp.net time-out

Asp.net web application times out on long running stored procedure