Command State Property Record State Property Recordset State Property Streamt State Property PROPERTY:  Connection::State long = connectionobject.State 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 Constanrs   Constant Value Description adStateClosed 0 Object is closed adStateOpen 1 Object is open adStateConnecting 2 Attempting to connect adStateExecuting   Not used adStateFetching   Not used   Code (VBScript): If (objConnection.State = adStateClosed) Then    Response.Write "Connection object is closed" End If Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved. Trademark Information