J
Joe Fallon
All of my short run queries work fine.
I have a long running query (over 1 minute).
I get an error in my VB.Net code that says the Timeout Expired.
The SQL Server connection string has a Timeout of 15 seconds.
But I thought that was just for the establishment of the connection itself.
(I tried changing it to 300 but still got a timeout after 37 seconds.)
Any ideas what is happening and how to fix it?
I have a long running query (over 1 minute).
I get an error in my VB.Net code that says the Timeout Expired.
The SQL Server connection string has a Timeout of 15 seconds.
But I thought that was just for the establishment of the connection itself.
(I tried changing it to 300 but still got a timeout after 37 seconds.)
Any ideas what is happening and how to fix it?