Thanks for your answer, Helen

One more question about this:

> When the connection shutdown sequence calls the Close() method of each
> transaction, each transaction's linked statement objects get cleaned
> up. In the case of some datasets, there might be a delay if there are
> unfetched rows, because the dataset object will deal with them first.
> If you don't call Connection.Disconnect explicitly, it will be done by the
> connection's owner.

Does the above imply that I should only use

Transaction.Close

not followed by

Connection.Disconnect

because the Close method has already taken care for that ?