Hi Pros., I have a application that connect to a SQL Server for retrieve the new data in every 5 minutes. But sometimes the SQL Server is disconnected. If I want to make my application retry the connection while the connection is downed and make it resume when the connection is back again, what should I do? Many thanks.
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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ADODB Connection - Reconnect
- Thread starter Crazyec
- Start date
JerryKlmns
IS-IT--Management
What if
Conn.State = 4 'adStateExecuting or
Conn.State = 8 'adStateFetching
if Conn.state <> adstateopen then
set conn = nothing
reopen connection
end if
might kill somebody!
better to check
If Conn.State = 0 Then 'adStateClosed
Set Conn = Nothing
reopen connection
End If
Conn.State = 4 'adStateExecuting or
Conn.State = 8 'adStateFetching
if Conn.state <> adstateopen then
set conn = nothing
reopen connection
end if
might kill somebody!
better to check
If Conn.State = 0 Then 'adStateClosed
Set Conn = Nothing
reopen connection
End If
- Thread starter
- #5
In order to do this correctly you are going to have to perform a query against the database. If the connection is terminated the Conn.state is not updated and it will still be open.
I have posted an example here before. Try doing a keyword search to find it.
I have posted an example here before. Try doing a keyword search to find it.
- Thread starter
- #7
Thank you, I think the thread you posted is
- Status
Similar threads
- Locked
- Question
