OleDbConnection.ConnectionTimeout Property

 

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 override int ConnectionTimeout { get; }

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 void InsertRow(string connectionString, string insertSQL)
{
    using (OleDbConnection connection = new OleDbConnection(connectionString))
    {
        // The insertSQL string contains a SQL statement that
        // inserts a new row in the source table.
        OleDbCommand command = 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 (Exception ex)
        {
            Console.WriteLine(ex.Message);
        }
        // The connection is automatically closed when the
        // code exits the using block.
    }
}

.NET Framework
Available since 1.1
Return to top
Show: