I have an mts object written in vb, named A. Its transaction mode is 'required transaction' A calls an object named B with mode 'uses transaction'. B calls a data access component C which accesses the database. C also has a mode of 'uses
transaction'. The number of calls to B from A are large.
I keep getting this error, after a method in object A is called:
"Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction."
I want to understand how and why this error comes up. I am not accessing distributed databases. IS this error saying that the transaction has already committed, and another database access is trying to commit the transaction again?
Do we have to encapsulate every write to the database with a
transaction, or can we combine a number of writes into one transaction, as I am doing?