Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2002-06-28
3
Medium Priority
?
2,499 Views
Last Modified: 2012-05-04
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
Comment
Question by:skel
3 Comments
 
LVL 2

Expert Comment

by:PUMASOFT
ID: 7121460
Can you supply more info, example of code?
0
 

Accepted Solution

by:
skel earned 0 total points
ID: 7121551
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
 

Expert Comment

by:CleanupPing
ID: 9280220
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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question