
ODBC Direct Connection still usuable.
We have a VB app, using ODBCDirect through DAO to connect to a SQL Server
6.5 database. What we would like to be able to do is to determine if a
Connection (or Database ) object still exists to the database at any point
in time. At present, the only thing we seem to be able to do is to try and
run the query and if an error occurs, depending on what the error is, we can
determine if the connection has gone down and if so attempt to reconnect.
This seems to be a clumsy way of doing things.
Is there any way to "poll" a connection and determine if it is still valid?
KEG