I have an SP that takes approximately 35 min. to complete.
My catch of the error:
ex.Message "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
Here is the app config setting:
add name="RadDev" connectionString="server=MyServer;Initial Catalog=db_Iris; Integrated Security=SSPI;Connect Timeout=42000"/
My timeout error only takes 30 seconds.
The call for the command:
' Setup sql command
Try
lConn.Open()
With lCmd
.Connection = lConn
.CommandType = CommandType.StoredProcedure
.CommandText = "usp_System_LoadIncidents"
End With
lCmd.ExecuteNonQuery()
Any ideas?