×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Error 8525. Distributed transaction completed. Either enlist this se

Error 8525. Distributed transaction completed. Either enlist this se

Error 8525. Distributed transaction completed. Either enlist this se

(OP)
I'm getting the message:

-2147217900 Distributed transaction completed. Either
enlist this session in a new transaction or the NULL
transaction.

I have one component running in COM+ which is defined
as "Requires Transaction".

First call I make to the component, it works without a
problem.

Subsequent calls receive the above message.

This is driving me nuts!  Please help if you can.

Thanks in advance!

Tarek

RE: Error 8525. Distributed transaction completed. Either enlist this se

Hi,

I encountered this error and its driving me nuts.  I usually encounter this when 2-3 pc's are calling the same component.

I tried to process lesser data by modifying the where clause in the SQL statement and it doesn't give any errors.  The recordset.Open command causes this error on a loop.  When the number of PC's using this component increases even if there's less data to process in a loop, I think the error will occur again.  It's somewhat related to data size.  I think the Com+ wants us to create a new transaction since it can't handle the large data or transaction it is processing.

Then after playing with the code, I get a BOF,EOF error while creating the object in the client.  I reviewed the code but there's no recordset that causes this.  It only happens if there are 2 or more pc's running the component.

If I didnt use the MTS/COm+, I didnt experienced any problems,except that its a little slow since it is being processed in the client.  

RE: Error 8525. Distributed transaction completed. Either enlist this se

Hi


I get this error (8525) when I try to commit a distributed transaction. The transaction is executed by a proc calling a remote proc through a linked server. Both servers run SQL 2k enterprise and are contained in the same cluster. I tried SQL server 2k sp3a as a solution but no luck. The amount of data is insignificant.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close