SQL Server Connection Timeout

[James1981]

Hi,

I have a Stored Procedure that takes a very long time to run, I'm getting a problem that I think is due to the connection to the DB timing out. Is there a default amount of time after which the connection times out if no result is given from the SQL server?

If so, how can I change this default value? My connection string is as follows:

Private Const SQL_CONNECTION_STRING As String = _
                "Server=IREA1SQLP100;" & _
                "DataBase=dsw_ecfilter_mk_delta;" & _
                "Uid=ecfilter_mk_delta_user;" & _
                "Pwd=er5t6*3B"
Dim scnnDelta As New SqlConnection(SQL_CONNECTION_STRING)

Thanks,

James

 

[woyler]

If the DB times out that error will be returned to the caller. Are you getting an error?

 

[sunaj]

Hi,

In VB6 the timeout was a property of the connection, in VB.net it is a property of the command object: CommandTimeout. the default value is 30 seconds.
-----------------------------
Dim Comm As New SqlCommand(YourTimeConsumingSQL, Conn)
Comm.CommandTimeout = 5 * 60 ' set the timeout to 5 minutes
----------------------------------------

Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'