ADODB Connection

[Joe Delphi]

Hi,

I want to test to see if my connection is already open before I call
the open method. Something like this:

Dim DBConn As ADODB.Connection

Set DBConn As New ADODB.Connection
..
..
<Bunch of stuff here>


If DBConn is Not Open Then
DBConn.Open

Can someone tell me which property to check to determine if a connection
already exists?


Thanks,
JD

 

[Douglas J. Steele]

If DBConn.State = adStateClosed Then
DBConn.Open
End If