SQL_ATTR_CONNECTION_DEAD

[Shane]

I have a cli application, which keeps a db connection during its
lifetime. Can I use SQLGetConnAttr( ) SQL_ATTR_CONNEC TION_DEAD to
verify the current connection state? Basically I want to switch to a
standby idle DB if the task detects broken db connection. Any
comments? Shane