Connection timeout for SQL server

by

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.

More Related Contents:

  1. Call a stored procedure with parameter in c#
  2. Insert 2 million rows into SQL Server quickly
  3. Fastest method for SQL Server inserts, updates, selects
  4. How to make an algorithm to get all column names from across tables that relations with their primary key in SQL Server and C#?
  5. Procedure or function xxxxx has too many arguments specified [duplicate]
  6. Calling stored procedure with return value
  7. Cannot open database “test” requested by the login. The login failed. Login failed for user ‘xyz\ASPNET’
  8. Pass table valued parameter using ADO.NET
  9. How to pass sqlparameter to IN()? [duplicate]
  10. How do I return multiple result sets with SqlCommand?
  11. Avoiding SQL injection without parameters
  12. When using Trusted_Connection=true and SQL Server authentication, will this affect performance?
  13. How to run multiple SQL commands in a single SQL connection?
  14. Queuing in OneWay WCF Messages using Windows Service and SQL Server
  15. MultipleActiveResultSets=True or multiple connections?
  16. Creating a SQL Server table from a C# datatable
  17. SQL: Update a row and returning a column value with 1 query
  18. How DataReader works?
  19. What SqlDbType maps to varBinary(max)?
  20. How to keep single SQL Server connection instance open for multiple request in C#?
  21. How to use SqlCommand to CREATE DATABASE with parameterized db name?
  22. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  23. How can I convert ticks to a date format?
  24. Retrieve image from database in asp.net
  25. What is passing parameters to SQL and why do I need it?
  26. What size do you use for varchar(MAX) in your parameter declaration?
  27. How to get efficient Sql Server deadlock handling in C# with ADO?
  28. Database Error: There is no row at position 0
  29. Passing array to a SQL Server Stored Procedure
  30. How to give ADO.NET Parameters

Leave a Comment