OleDbConnection.ConnectionTimeout Property

 
System_CAPS_noteNote

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

Gets the time to wait while trying to establish a connection before terminating the attempt and generating an error.

Namespace:   System.Data.OleDb
Assembly:  System.Data (in System.Data.dll)

Public Overrides ReadOnly Property ConnectionTimeout As Integer

Property Value

Type: System.Int32

The time in seconds to wait for a connection to open. The default value is 15 seconds.

Exception Condition
ArgumentException

The value set is less than 0.

A value of 0 indicates no limit, and should be avoided in a ConnectionString because an attempt to connect will wait indefinitely.

The following example creates an OleDbConnection and sets some of its properties in the connection string.

' The connectionString argument contains the Connect Timeout 
' keywords, as follows: "... ;Connect Timeout=30;"
Public Sub InsertRow(ByVal connectionString As String, _
    ByVal insertSQL As String)

    Using connection As New OleDbConnection(connectionString)
        ' The insertSQL string contains a SQL statement that
        ' inserts a new row in the source table.
        Dim command As New OleDbCommand(insertSQL)

        ' Set the Connection to the new OleDbConnection.
        command.Connection = connection

        ' Open the connection and execute the insert command.
        Try
            connection.Open()
            command.ExecuteNonQuery()
        Catch ex As Exception
            Console.WriteLine(ex.Message)
        End Try
        ' The connection is automatically closed when the
        ' code exits the Using block.
    End Using
End Sub

.NET Framework
Available since 1.1
Return to top
Show: