OleDbConnection.ConnectionTimeout OleDbConnection.ConnectionTimeout OleDbConnection.ConnectionTimeout OleDbConnection.ConnectionTimeout Property

정의

시도를 종료하고 오류를 생성하기 전에 연결하는 동안 대기할 시간을 가져옵니다.Gets the time to wait while trying to establish a connection before terminating the attempt and generating an error.

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

속성 값

연결이 열릴 때까지 대기하는 시간(초)입니다.The time in seconds to wait for a connection to open. 기본값은 15초입니다.The default value is 15 seconds.

구현

예외

설정한 값이 0보다 작은 경우The value set is less than 0.

예제

다음 예제에서는 OleDbConnection 연결 문자열에 해당 속성 중 일부를 가져오거나 설정 합니다.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

설명

값 0은 제한 없음을 나타냄 및 피해 야를 ConnectionString 연결에서 무기한으로 대기 하므로 합니다.A value of 0 indicates no limit, and should be avoided in a ConnectionString because an attempt to connect will wait indefinitely.

적용 대상

추가 정보