>Does anyone know how to test the actual ADODB connection to determine if it is open or not? In the application I am using, I can't simply test to see if an ADODB object has been instantiated. I need to test the connection itself.
>
>Thanks in advance

Check the State property of the connection object.