User transaction is already in progress

[djb]

Is it possible to nest transactions using the same connection?

When I do the following, I get the 'User transaction is already in progress' on the second call to StartTransaction():

Connection.StartTransaction
Query1.Execute;
Connection.StartTransaction
Query2.Execute;
...

Thanks.

[Jackson]

OLE DB Providers that are used by SDAC do not support nested transactions.