how to set the query timeout from SQL connection string

Question

i want to set the querytimeout fromt he connection string. not the connection timeout , is it possible?

Answer 1

No. It's per command, not per connection.

Answer 2

See:- ConnectionStrings content on this subject. There is no default command timeout property.

Answer 3

You can only set the connection timeout on the connection string, the timeout for your query would normally be on the command timeout. (Assuming we are talking .net here, I can't really tell from your question).

However the command timeout has no effect when the command is executed against a context connection (a SqlConnection opened with "context connection=true" in the connection string).

Answer 4

This work for me:

connectionString = "Server=NoExist;Database=tempdb;User ID=sa;Password=12345678;Connection Timeout=2;"