1. Home

ADO State Property

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."

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

❮ Complete Connection Object Reference

Categories

HTML CSS3 Bootstrap Foundation Sass JavaScript TypeScript JQuery AngularJS React NodeJS Highcharts PHP Python Python3 Django Linux Docker Ruby Java C C ++ Perl Servlet JSP Lua Scala Go ASP C # SQL MySQL SQLite MongoDB Redis Android Swift ionic Kotlin XML tutorial

Contact US