• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2513
  • 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

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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