Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to check if ADODB connection is open? 1
- Thread starter 99mel
- Start date
-
1
- #2
BobLoblaws
Programmer
If adConn.State = adStateOpen Then
' Connection is open
Else
' Connection is closed
End If
adStateOpen = 1
adStateClosed = 0
' Connection is open
Else
' Connection is closed
End If
adStateOpen = 1
adStateClosed = 0
- Thread starter
- #3
BobLoblaws
Programmer
if not adConn is nothing then
' do some stuff
else
' can't use adconn
end if
As well, you might be getting that error if you do not Set adConn = New ADODB.Connection before you try to make a connection.
' do some stuff
else
' can't use adconn
end if
As well, you might be getting that error if you do not Set adConn = New ADODB.Connection before you try to make a connection.
- Thread starter
- #5
- Thread starter
- #7
- Status
Similar threads
- Locked
- Question
- Locked
- Question
