Distributed transaction completed. Either enlist this session in a new transaction or the Null Trans

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hybrid View

Distributed transaction completed. Either enlist this session in a new transaction or the Null Trans

I am getting the following error message:
Error -2147217900
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)