Page 1 of 1

User transaction is already in progress

Posted: Sun 28 Jan 2007 16:18
by 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.

Posted: Tue 30 Jan 2007 13:06
by Jackson
OLE DB Providers that are used by SDAC do not support nested transactions.