Unable to start transaction: Transaction is active

Benson Wong

Delphi Developer

Mon, 01 Mar 2004 17:50:54 GMT

Unable to start transaction: Transaction is active

I have encountered the above msg. in my apps. I am now using D5, IB6.0 as
the development environment. I suspect the above msg. is generated by IB6.

What's the meaning of the above msg? It appears sometimes on my exit of my
AR transaction Entry program. Fogot to close tables? forgot to
dataset.cancel?

Benson.

Team

Delphi Developer

Mon, 01 Mar 2004 22:09:46 GMT

Re:Unable to start transaction: Transaction is active

The message means that you are trying to start a transaction when a
transaction is already active. You need to commit the active transaction
before you start a new one. What are you using for your client application
(Delphi, C++ Builder, ???)? Which data access components are you using (IBX,
dbExpress, BDE)?

--
Bill
(TeamB cannot answer questions received via email)

Other Threads

1. Next transaction older than oldest active transaction

2. Oldest transaction, Active, Snapshot, Next Transaction values

3. SQL Server and Delphi: START TRANSACTION vs maximum of transactions

4. invalid transaction handle (expecting explicit transaction start)

5. Error 335544332 Invalid transaction handle (expecting explicit transaction start)

6. invalid transaction handle (expecting explicit transaction start)

7. invalid transaction handle (expecting explicit transaction start)

8. invalid transaction handle (expecting explicit transaction start)

9. invalid transaction handle (expecting explicit transaction start)

10. Tricky transaction problem: Catching EDatabaseError from one of several Post within a transaction