MTS / DTC not rollling back transaction 
Author Message
 MTS / DTC not rollling back transaction

Hi,

I am not able to get MTS to rollback transaction. I am running VB6 SP3 /
NT40 SP4 / MTS 2 / SQL Server 6.5.

Here is the scenario:

CreateObject from client MainWrapperClass    Supports Transactions
    MainWrapperClass  Creates Instances of TransactionWrapperClass
Requires Transaction
        TransactionWrapperClass    Creates Instances of Table Class A
Supports Transactions
        TransactionWrapperClass    Creates Instances of Table Class B
Supports Transactions

each method called in each class calls SetAbort in the error handler or
setcomplete at the end of the method

When I force Class B to fail (with a timestamp error) the changes to Class
A's data are not rolled back.

Any help would be greatly appreciated...

Thanks and please post to group,
Dave



Sat, 05 Jan 2002 03:00:00 GMT  
 MTS / DTC not rollling back transaction
Dave,

What happens if you change MainWrapperClass to RequiresTransaction?

Later...

Niels


Quote:
>Hi,

>I am not able to get MTS to rollback transaction. I am running VB6 SP3 /
>NT40 SP4 / MTS 2 / SQL Server 6.5.

>Here is the scenario:

>CreateObject from client MainWrapperClass    Supports Transactions
>    MainWrapperClass  Creates Instances of TransactionWrapperClass
>Requires Transaction
>        TransactionWrapperClass    Creates Instances of Table Class A
>Supports Transactions
>        TransactionWrapperClass    Creates Instances of Table Class B
>Supports Transactions

>each method called in each class calls SetAbort in the error handler or
>setcomplete at the end of the method

>When I force Class B to fail (with a timestamp error) the changes to Class
>A's data are not rolled back.

>Any help would be greatly appreciated...

>Thanks and please post to group,
>Dave



Sat, 05 Jan 2002 03:00:00 GMT  
 MTS / DTC not rollling back transaction
Niels

I cannot do that without causing transactions to be started for retrieving
data and validating data

Dave


Quote:
> Dave,

> What happens if you change MainWrapperClass to RequiresTransaction?

> Later...

> Niels



> >Hi,

> >I am not able to get MTS to rollback transaction. I am running VB6 SP3 /
> >NT40 SP4 / MTS 2 / SQL Server 6.5.

> >Here is the scenario:

> >CreateObject from client MainWrapperClass    Supports Transactions
> >    MainWrapperClass  Creates Instances of TransactionWrapperClass
> >Requires Transaction
> >        TransactionWrapperClass    Creates Instances of Table Class A
> >Supports Transactions
> >        TransactionWrapperClass    Creates Instances of Table Class B
> >Supports Transactions

> >each method called in each class calls SetAbort in the error handler or
> >setcomplete at the end of the method

> >When I force Class B to fail (with a timestamp error) the changes to
Class
> >A's data are not rolled back.

> >Any help would be greatly appreciated...

> >Thanks and please post to group,
> >Dave



Sat, 05 Jan 2002 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. MTS / DTC not rollling back transaction

2. MTS / DTC not rollling back transaction

3. ODBC, MTS, MS DTC Distributed transaction error

4. MTS, VB and rolling back transactions

5. COM+ question: SetAbort not rolling back transaction?

6. SetAbort does not roll back transaction

7. When to use MTS transactions and ADO Transactions

8. To Transaction or Not to Transaction that is the question

9. Why to use COM+ transaction and not just SQL Server transaction

10. Why to use COM+ transaction and not just SQL Server transaction

11. How to use MTS Style Transactions in VB.Net

12. MTS - Microsoft Transaction Server

 

 
Powered by phpBB® Forum Software