Calling Stored Procedure from VB.net timeout error
Posted
by Jim
on Stack Overflow
See other posts from Stack Overflow
or by Jim
Published on 2010-04-23T15:12:42Z
Indexed on
2010/04/23
15:23 UTC
Read the original article
Hit count: 239
When calling a stored procedure from vb.net is there a default SQL timeout time if no timeout is specified in the connection string?
I am unsure if there is a CommandTimeout
specified in the connection string but am going through all the possibilites.
Example if no results after 30 seconds (or more) throw:
`System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.`
SQL Profiler says that the script runs and ends in 30 seconds when the program timesout..
Tthe script runs without error in about 1 minute 45 seconds by itself in SQL server.
© Stack Overflow or respective owner