Hello there,

I'm writing a generic error handler where I want to
test the connection state to my databases. (SQLServer 7
via OLEdb)

Unfortunately (perhaps because I'm using the data
environment?) the 'State' property of the connection object
does'nt change whenever the database isn't accessible.

I have also tried to use the "Connection Status" member
of the Connection.Properties's collection, but in some case
this property doesn't exist.

So how do I detect a connection failure to my databases
when using ADO?

TIA.