What is the best way to determine if I've lost connectivity to my database?
I'm establishing connectivity when I start my process, then do several
SQLExecDirects throughout. In a few tests I've run, I get back errors on
the SQLExecDirect if the database is down, but is there an easy way to
determine if the error is because the database is down or because there's a
problem with my SQL statment? Is this something that is dependent on the
type of database and driver?
Thanks in advance,
Kathy Rathy