OdbcConnection.Close Method

public:
 override void Close();

public:
 virtual void Close();

public override void Close ();

public void Close ();

override this.Close : unit -> unit

abstract member Close : unit -> unit
override this.Close : unit -> unit

Public Overrides Sub Close ()

Public Sub Close ()

Implements

Examples

The following example creates an OdbcConnection, opens it, displays some of its properties, and then closes the connection.

private static void CreateOdbcConnection(string connectionString)
{
    using (OdbcConnection connection = new OdbcConnection(connectionString))
    {
        connection.Open();
        Console.WriteLine("ServerVersion: " + connection.ServerVersion
            + "\nDatabase: " + connection.Database);

        // The connection is automatically closed at
        // the end of the Using block.
    }
}

Private Sub CreateOdbcConnection(ByVal connectionString As String)
    Using connection As New OdbcConnection(connectionString)
        With connection
            .Open()
            Console.WriteLine("ServerVersion: " & .ServerVersion _
               & vbCrLf + "Database: " & .Database)
        End With

        ' The connection is automatically closed
        ' at the end of the Using block.
    End Using 
End Sub

Remarks

The Close method rolls back any pending transactions. It then releases the connection to the connection pool, or closes the connection if connection pooling is disabled. If Close is called while handling a StateChange event, no additional StateChange events are fired.

An application can call Close more than one time without generating an exception.

Applies to

See also

• Connecting to Data Sources