Pelle,

> No doubt I will make use of several transactions, however I am not
> sure if I will be using more than one connection (unless there are
> some benefits of doing so ?).

The benefits are for example when you're working with dll's that need a
connection to the database, too.
Instead of establishing a new connection within the dll you can pass the
handle of your main app connection and let the dll use (share) this
connection, too.


Luc.