Validate open ADO connection

[Glory]

How do I check to see if a connection is currently open?

 

[Glory]

It looks like you can't.

Once a connection is open, the status is open. This just means you have a handle, not that the connection still works. I think the only way is to attempt to use the connection and trap the possible error. However, you suffer the timeout. I don't think I've seen any way to test a connection, other than to attempt to use it (Open method of Recordset object or Execute method of Command object).

 

[ukmikeb]

How do I check to see if a connection is currently open?

As in this URL -
http://www.devguru.com/Technologies/ado/quickref/connection_state.html

hth