OdbcConnection.State Property


Gets the current state of the connection.

 property System::Data::ConnectionState State { System::Data::ConnectionState get(); };
public System.Data.ConnectionState State { get; }
member this.State : System.Data.ConnectionState
Public ReadOnly Property State As ConnectionState

Property Value

A bitwise combination of the ConnectionState values. The default is Closed.



The following are allowed state changes:

  • From Closed to Open, using the Open method.

  • From Open to Closed, using either the Close or Dispose method.


Calling the State property on an open connection increases application overhead because each such call causes a SQL_ATTR_CONNECTION_DEAD call to the underlying ODBC driver to determine whether the connection is still valid.

Applies to

See also