OleDbConnection.ConnectionTimeout Propriedade

Definição

Obtém o tempo de espera (em segundos) durante a tentativa de estabelecimento da conexão antes que a tentativa seja terminada e um erro seja gerado.Gets the time to wait (in seconds) while trying to establish a connection before terminating the attempt and generating an error.

public:
 property int ConnectionTimeout { int get(); };
[System.Data.DataSysDescription("OleDbConnection_ConnectionTimeout")]
public int ConnectionTimeout { get; }
member this.ConnectionTimeout : int
Public ReadOnly Property ConnectionTimeout As Integer

Valor da propriedade

O tempo (em segundos) de espera para abrir uma conexão.The time in seconds to wait for a connection to open. O valor padrão é 15 segundos.The default value is 15 seconds.

Implementações

Atributos

Exceções

O valor definido é menor que 0.The value set is less than 0.

Exemplos

O exemplo a seguir cria um OleDbConnection e define algumas de suas propriedades na cadeia de conexão.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.
    }
}
' 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

Comentários

Um valor de 0 indica sem limite e deve ser evitado em uma ConnectionString porque uma tentativa de conexão será esperada indefinidamente.A value of 0 indicates no limit, and should be avoided in a ConnectionString because an attempt to connect will wait indefinitely.

Aplica-se a

Veja também