ADO » Connection » State

long = connectionobject.State

Returns a long value (the ObjectStateEnum value) describing if the connection is open or closed.

The State property returns a long value that is the sum of one or more ObjectStateEnum constants. These constants describe if the Connection object is open, closed, or connecting.

The adStateExecuting and adStateFetching constants are not used. The default value is adStateClosed.

You can call the State property at any time.
ObjectStateEnum Constants

Constant Value Description
adStateClosed 0 Object is closed
adStateOpen 1 Object is open
adStateConnecting 2 Attempting to connect
adStateExecuting   Not used
adStateFetching   Not used


If (objConnection.State = adStateClosed) Then
   Response.Write "Connection object is closed"
End If

See Also: