To increase the timeout period

Question

hi guys,

I have to increase timeout period.Following is my code.

Private Function GetConnectionInstance() As SqlConnection
    Dim objConn As SqlConnection
    Dim strConnection As String
    strConnection = ConfigurationSettings.AppSettings("conn")

    Try
        objConn = New SqlConnection(strConnection)
    Catch ex As Exception
    End Try

    Return objConn
End Function

What code i have to add in above to increase timeout period.

Answer 1

You need to add the next item into your connection string:

Connection Timeout=30;

If you need to change Timeout only for target connection, not in the whole application, do next:

Dim connString as String = ConfigurationSettings.AppSettings("conn")
Dim builder As New SqlConnectionStringBuilder(connString)
builder.Timeout = 30;
Dim connection = New SqlConnection(builder.ToString())

Answer 2

You can alter the connection string by adding "Connection Timeout = 30" to it. The default 15 and it is in seconds. However important to know is where the timeout actually occurs. You should check this topic: Timeout not being honoured in connection string.