I have a VB
app that that runs on one PC and accesses SQL server running on another PC using ADO. I am trying to determine the best way to detect when SQL server is no longer available due to being shutdown or a network problem.
The app keeps a connection open all the time. It uses recordsets to get read and write data when needed.
I would like to detect the moment SQL server goes down so that before running a query the state of the server will be known and handled accordingly.
I found the Disconnect event and the State property in the Connection object of little use.
Thanks in advance,