If I get an ODBC error during executing sqlexec(), how can I tell whether I can execute another sqlexec() or not? I'm writing an error handling routine which will update sql server table with the error information. However, if the error is caused by connection problem, I should not execute sqlexec() to update the sql server table otherwise it will generate another error.

Thank you for any help.