Re: detect disconnected Database by ADO

Is-it possible to know the ADO connection state of a Database
(_ConnectionPtr) ?
The property State give the previous command state.
Is there a method to know the connection state (synchronous) ? (for
example to know if the database is down , or the server is unavailable,
...)

Do a Connection Execute of "SELECT 1" and see what the Status is afterwards.
It is the cheapest round-trip SELECT.

Stephen Howe


.