Hi,
I am trying to adjust the duration a remote query before timing out to 10
minutes. My connection string is: "data source=mydbserver;Initial
Catalog=mydb;Integrated Security=SSPI;Connect Timeout=600;". Curiously,
while running a very long running test query, ADO.Net throws a timeout error
from the command after 60 seconds, not 600. Examination of the active
connection at the point of error indicates that the connection timeout is
600 as it should be. My SQL server is configured to the default value for
Query time out of 10 minutes.

Any ideas why this is happening, or what I need to do to explicitly set the
max allowed time to execute a query.

TIA!


MS Sql Server LazyDBA home page