Hi David
>Jojo,
>
>Since you copied me I'll post back a couple of thoughts.
>...
>If your object that manages the connection uses a wrapper method for SQLExec() then you can easily check the result and if it errors check the error and if the error indicates a connection failure problem it can SQLDisconnect() on the bad connection, reestablish a new connection and retry the SQL command.
Thanks, I had put up similar basic thoughts to Jojo for the same, though I must confess I was not able to pen them is as well. Thanks for confirming my thoughts.