>connection is made at start of application. But status of connection needs to be tested before each sqlexec(). App could be running for along time and lose connection. Then SQLexec() could fail. The idea is to test the connection before issuing SQLexex()

Miles,

You may want to try looking up the SQLGETPROP() function to see if any of those properties help you out.

Laterness,
Jon