Nested transaction and MSSQL problem

Miro Penchev

Delphi Developer

Tue, 09 Sep 2003 18:59:42 GMT

Nested transaction and MSSQL problem

Hi, ALL

We have application that uses ADO 2.5 and Jet provider. In application have
lot of nested transactions. Now we must change database to MSSQL 7 and I get
exception that nested transactions is not supported. How we can solve this
problem without rewriting application (it more complex and must support MS
Access databases)? Whether ADO 2.6 supports nested transactions against
MSSQL 7.0?

TIA,

Miro.

Other Threads

1. Nested Transaction (MSSQL)

2. Still Problems with Nested Transactions in D4 C/S, BDE 5, IB5

3. MSSQL problem with integer keys and nested datasets

4. Delphi 5 + ADO + MSSQL 7 Transaction problem

5. Problem with MSSQL Server and Delphi Transactions

6. Problem with Delphi 5, ADO, MSSQL 7 with Transaction

7. Transaction problem, MSSQL 6.5 please help

8. Transaction problem: An abort after it's commit (MSSQL 6.5 delphi 2.0 c/s)

9. Transaction Log Problem in MSSQL 6.5

10. Nested transactions