VB & Database, MTS / DTC not rollling back transaction

MTS / DTC not rollling back transaction

Author	Message
DPSatHy #1 / 3	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

Niels Berglu #2 / 3	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

DPSatHy #3 / 3	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

Page 1 of 1

[ 3 post ]