W3Schools.com

ADO State Property

Connection Object Reference Complete Connection Object Reference

The State property returns a value that describes if the object is open, closed, connecting, executing or retrieving data. The value returns an ObjectStateEnum value. Default is adStateClosed.

This property can be used with the Command, Connection, Record, Recordset, and Stream object.

The State property can have a combination of values. If a statement is executing, this property will have a combined value of adStateOpen and adStateExecuting.

Syntax

object.State

Example

For a Command object:

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"

set comm=Server.CreateObject("ADODB.Command")
response.write(comm.State)

conn.close
%>

For a Connection object:

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"

response.write(conn.State)

conn.close
%>

ObjectStateEnum Values

Specifies whether an object is open or closed, connecting to a data source, executing a command, or retrieving data.

Constant Value Description
adStateClosed 0 The object is closed
adStateOpen 1 The object is open
adStateConnecting 2 The object is connecting
adStateExecuting 4 The object is executing a command
adStateFetching 8 The rows of the object are being retrieved

Connection Object Reference Complete Connection Object Reference
WEB HOSTING
Best Web Hosting
PHP MySQL Hosting
Best Hosting Coupons
UK Reseller Hosting
Cloud Hosting
Top Web Hosting
$7.95/mo SEO Hosting
Premium Website Design
WEB BUILDING
XML Editor - Free Trial!
FREE Website BUILDER
Free Website Templates Free CSS Templates
Make Your Own Website
W3SCHOOLS EXAMS
Get Certified in:
HTML, CSS, JavaScript, XML, PHP, and ASP
W3SCHOOLS BOOKS
New Books:
HTML, CSS
JavaScript, and Ajax
STATISTICS
Browser Statistics
Browser OS
Browser Display
SHARE THIS PAGE