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: 220

Filed under:
|
|
|

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

Related posts about vb.net

Related posts about sql