• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2524
  • Last Modified:

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

Environment:

Windows 2000 Server
Visual Basic 6.0
SQL Server2000

That error is thrown withing a Visual Basic component. How to solve it?

Thanks
0
skel
Asked:
skel
1 Solution
 
PUMASOFTCommented:
Can you supply more info, example of code?
0
 
skelAuthor Commented:
I cannot because I don't know where is the problem and the code is very big. But someone gave me a hint without the need of looking the code. Maybe the SQL statement delays too much, more than the timeout defined for the component in Component Services (in fact, it delays more than 60 sec, which is the default), so that the component services deactivate the component before the SQL query return data to it. I changed that timeout definition but I can test that change tomorrow.

Thanks
Jaime
0
 
CleanupPingCommented:
skel:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now