Timeout Expired

[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?

 

[Joe Fallon]

Found it - the default of the command object is 15.

cmd.CommandTimeout = 300