Time Out Error in ASP.Net

asp.net sql-server connection-timeout command-timeout
Sayanthan picture Sayanthan · Oct 12, 2011 · Viewed 9.5k times · Source

How can I stop time out error for executing SQL query in ASP.Net? I researched in Google but I couldn't solve my problem correctly.

Answer

kst picture kst · Oct 12, 2011

I think your problem is about CommandTimeOut.The time (in seconds) to wait for the command to execute. The default is 30 seconds. Here is full example. Otherwise, you should set the ConnectionTimeOut in your database connection string. Something like that

<add key="ConnString2" value="Provider=SQLOLEDB;User Id=sa;PASSWORD=1;
SERVER=BlurBlur;database=BlurBlur;Connect Timeout=60;"/>

If you use the UpdatePanel, set the AsyncPostBackTimeout.

<asp:ScriptManager ID="ScriptManager1" runat="server" 
AsyncPostBackTimeout ="360000"></asp:ScriptManager>

to be more sure

<httpRuntime executionTimeout="360000"/>

Related questions

Call a stored procedure with parameter in c#

I can do a delete, insert and update in my program and I try to do an insert by call a created stored procedure from my database. This a button insert I make work well. private void btnAdd_Click(object …

Read More
How can I solve a connection pool problem between ASP.NET and SQL Server?

The last few days we see this error message in our website too much: "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and …

Read More
Cannot open database "test" requested by the login. The login failed. Login failed for user 'xyz\ASPNET'

I have created a web service which is saving some data into to db. But I am getting this error: Cannot open database "test" requested by the login. The login failed. Login failed for user 'xyz\ASPNET'. My connection string …

Read More