What is “Connect Timeout” in sql server connection string?

by

That is the timeout to create the connection, NOT a timeout for commands executed over that connection.

See for instance http://www.connectionstrings.com/all-sql-server-connection-string-keywords/
(note that the property is “Connect Timeout” (or “Connection Timeout”), not just “Timeout”)

From the comments:

It is not possible to set the command timeout through the connection string. However, the SqlCommand has a CommandTimeout property (derived from DbCommand) where you can set a timeout (in seconds) per command.

Do note that when you loop over query results with Read(), the timeout is reset on every read. The timeout is for each network request, not for the total connection.

More Related Contents:

  1. How to create a specific SQL Server stored procedure? [closed]
  2. SQL Server – Best way to get identity of inserted row?
  3. Should I use != or for not equal in T-SQL?
  4. How to update two tables in one statement in SQL Server 2005?
  5. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  6. Foreign Key to non-primary key
  7. Difference between left join and right join in SQL Server [duplicate]
  8. Is the NOLOCK (Sql Server hint) bad practice?
  9. Creating table names that are reserved words/keywords in MS SQL Server [closed]
  10. Dynamic SQL – EXEC(@SQL) versus EXEC SP_EXECUTESQL(@SQL)
  11. Get all dates between two dates in SQL Server
  12. Pass table as parameter into sql server UDF
  13. There are no primary or candidate keys in the referenced table that match the referencing column list in the foreign key
  14. SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints
  15. Rename column SQL Server 2008
  16. Compare DATETIME and DATE ignoring time portion
  17. Fastest way to determine if record exists
  18. SQL – Query to get server’s IP address
  19. How to concatenate many rows with same id in sql?
  20. Why does using an Underscore character in a LIKE filter give me all the results?
  21. How to select date without time in SQL
  22. Generate nested nth level JSON SQL Server using recursive CTE
  23. Update query using Subquery in Sql Server
  24. “SELECT DISTINCT” ignores different cases
  25. T-SQL: checking for email format
  26. Script entire database SQL-Server
  27. Why is 30 the default length for VARCHAR when using CAST?
  28. case statement in SQL, how to return multiple variables?
  29. Calculate exact date difference in years using SQL
  30. Count number of NULL values in each column in SQL

Leave a Comment