I have written an NT service using VB 6.0. Occasionally the service will crash because of the database being shut down for whatever reason. I need to somehow check to see if the db server is operational again or not.
I'm able to detect the lost connection and have redirected the program to a loop that closes the current connection attempts to reconnect.
Problem is that during this loop, if the DB server is still down, there is an MSSQL error message dialog that appears along with a login dialog box, both of which cannot be answered because this app is an NT service!
Using: VB6 SP5, DAO 3.6, MSSQL 7 and 2000 (And Oracle and Sybase Anywhere)
Disconnected recordsets will not be acceptable.
Any innovative ideas along the lines of:
Reestablishign a connection in a "quiet" way (so there are no dialogs).
Other ways of detecting the lost db server before the db sections in the code
Any other ideas?