Connection timeout for SQL server

c# asp.net sql-server ado.net
zachary picture zachary · Nov 29, 2010 · Viewed 289.6k times · Source

Can I increase the timeout by modifying the connection string in the web.config?

Answer

Darin Dimitrov picture Darin Dimitrov · Nov 29, 2010

Yes, you could append ;Connection Timeout=30 to your connection string and specify the value you wish.

The timeout value set in the Connection Timeout property is a time expressed in seconds. If this property isn't set, the timeout value for the connection is the default value (15 seconds).

Moreover, setting the timeout value to 0, you are specifying that your attempt to connect waits an infinite time. As described in the documentation, this is something that you shouldn't set in your connection string:

A value of 0 indicates no limit, and should be avoided in a ConnectionString because an attempt to connect waits indefinitely.

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
Insert 2 million rows into SQL Server quickly

I have to insert about 2 million rows from a text file. And with inserting I have to create some master tables. What is the best and fast way to insert such a large set of data into SQL Server?

Read More
How can I retrieve a table from stored procedure to a datatable?

I created a stored procedure so as to return me a table. Something like this: create procedure sp_returnTable body of procedure select * from table end When I call this stored procedure on the frontend what code do I need …

Read More