Quick References
      ADO
      ASP
      CSS2
      HTML
      JavaScript
      Jet SQL
      VBScript
      WML
      WMLScript
      WSH
      XHTML
      XML DOM
      XSLT

Features
      Knowledge Base
      Tutorials

Partners
     ZVON.ORG
     XML
     Planet Source Code
     VisualBuilder
     Web Design
     Your HTML Source
     XML/XSLT Forums
     ASPAlliance
     Scripts
     
     Programmers Heaven
     Tek-Tips Forums
     Developer Fusion
     Code Project











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-2005 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information