Why is SQL Connection Timeout always 30 seconds?
I have used the VB data connection wizard to create a connection string which has a connection timeout of 120 seconds. I find emperically that it does not matter what timeout I provide in the connection string; it is always 30 seconds.
Data Source=xxx;Initial Catalog=xxx;Persist Security Info=True;User ID=xxx;Password=xxx;Asynchronous Processing=False;Connect Timeout=120;TrustServerCertificate=True;User Instance=False;Context Connection=False
[448 byte] By [
Gary] at [2008-1-24]
OK - I answered my own question.
The connection timeout is the time allotted to connect.
It is the command timeout that sets the response time.
I simply needed to add the following to the autogenerated code:
Me._commandCollection(x).CommandTimeout = 120
OK - I answered my own question.
The connection timeout is the time allotted to connect.
It is the command timeout that sets the response time.
I simply needed to add the following to the autogenerated code:
Me._commandCollection(x).CommandTimeout = 120
