>hi BOb,
>
>Disconnect is just an example.
>Suppose The lan goes down ??

If the server looses the connection it will rollback.

>The server MUST NOT commit the transaction unless a commit is recived but here there seems to a problem.

Commit was received, because it was sent by the SQLDisc(). Perhaps that shouldn't happen, but now that you know about it, it's not a big issue.

I would recommend explicitly coding all SQLCommit() and SQLRollback().

BOb