> >Can someone tell me why this code leaves the database connected?
>
> Among other reasons, you don't check return codes. If commit has
> failed for any reason, the transaction is still active and you must
> rollback it.
>
> BTW, I'd like to find out a way to check whether all transactions
> are finished inside a connection and if not - rollback them forcedly.
> So far I don't see any way to do it. Any suggestion?
>
> SY, Dimitry Sibiryakov.

yes - I was simplifying - I do check and the return code was OK
(I had another connection open for events)
but no I do not know how to retrieve all transaction handles other than
keeping them client side when you start it.
Alan