I am using a laptop connected to a PC card and in a timely fashion, need to check if there is a connection and continue with an update. Currently I am using code that creates a linked table through an ODBC connection. The process will fail when there is no connection. The problem is, when the attempt is made, I have to shut down the application and reopen, even if the connection has been reatored.
Is there any way in checking to see if the ODBC connection is Present before I try to refresh a link or create a new table?
Is there a way find the Instance of SQL server being used is available without having any affect on the application so that I don't have to reopen it again?
Any help would be greatly appreciated.