Distributed transaction completed. Either enlist this session in a new transaction or the Null Trans
I am getting the following error message:
Distributed transaction completed. Either enlist this session in a new transaction
or the Null Transaction.
I am getting this when I try to get a disconnected recordset using a component
that uses transactions. One of the recommendations that I found on the microsoft
website, was to not make the call of the method under a context of a transaction,
but I am still getting this error. I have several objects where I get a disconnected
recordsets, but I am not getting this error, this is only happening with
one specific object. One thing that happens is that my method works fine
the first 4 times, after the time I get the error, either when I am triying
to get one record from the table or a complete list (about 6000 records)
What could it be?