Navigation:  ThinBASIC Modules > ADODB > ADODB Module Classes > ADODB_Connection > ADODB_Connection Properties >

<ADODB_Connection>.State

Previous pageReturn to chapter overviewNext page

 

Description

 
Returns a value that describes if the object is open, closed, connecting, executing or retrieving data.

 

Syntax

 

n = <ADODB_Connection>.State

 

Returns

 

Number: Connection State.

 

Possible values:

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

 

Parameters

 

Name

Type

Optional

Meaning





 

 

Remarks

 

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

 

Restrictions

 

See also

 

Examples

 

String sConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & APP_SourcePath & "Biblio.mdb"

 

'---Declare a new pConnection variable and instantiate it in one line

Dim pConnection As New ADODB_CONNECTION '[(sConn)]

'---Set connection string

pConnection.ConnectionString = sConn

'---Open connection. Connection string is taken from ConnectionString property

pConnection.Open

 

If pConnection.State = %ADSTATEOPEN Then

  PrintL "-Connection is open-" In %CCOLOR_FLIGHTGREEN

Else

  PrintL "-It was not possible to open a connection-" In %CCOLOR_FLIGHTRED

End If