ConnectionState
Describes the current state of the connection to a data source.
Broken = 16
The connection to the data source is broken. This can occur only after the connection has been opened. A connection in this state may be closed and then re-opened. (This value is reserved for future versions of the product.)
Closed = 0
The connection is closed.
Connecting = 2
The connection object is connecting to the data source.
Executing = 4
The connection object is executing a command. (This value is reserved for future versions of the product.)
Fetching = 8
The connection object is retrieving data. (This value is reserved for future versions of the product.)
Open = 1
The connection is open.