I insert a row, and the component runs to setcomplete,<br>but awaits message from DTC. <br><br>In sql server the log message reads: "Awaiting DTC message, UOW ...guid...State PREPAR". The same component runs on another machine under windows 2000; but will not run on this machine under NT 4.0. <br><br>Any ideas?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
mts inserts, locks table, and never releases table lock!
- Thread starter alk
- Start date
- Thread starter
- #2
Apparently, if the dtc on the server fails, the process<br>is orphaned and all locks are kept indefinitely. Check<br>this URL:<A HREF=" TARGET="_new">
- Thread starter
- #3
There is more to this matter. Apparently,<br>there is some incompatability between the<br>referenced libraries in win 2000 and NT 4.0.<br>(the com+ reference vs. the MTS libraries).<br>When doing transactions, dtc does not<br>send a "commit" message to sql server, and<br>the whole thing hangs (forever). Maybe there<br>is a work-around; but I hear other shops <br>having this problem (and other problems too).
- Status
Similar threads
- Locked
- Question
- Locked
- Question