Unanswered: new transaction cannot enlist .......pls help
pls help me out tosort out this bug .....
My MTS component(developed using ATL and using ADO to acces SQL Server) running on Win 2k behaving well normally without any error,but sometimes it abort when firing a sQL query before deafult transaction time out period ( 60 sec) and produce following error in event log file:- "New transaction cannot enlist in the specified transaction coordinator"
This error is occuring sometimes not very often.Pls tell what can be its reason and how to fix it .
Other entries in event log file is as:-
(3016,2828)2003/09/16 15:46:00.638 H:0337 W:10158080 P:4603904 ERROR: COM
Exception in setConnection() [DbKernel.cpp(75)]
ADO ERROR @: File name=C:\Program Files\.....mercury_wms.udl
ADO ERROR 1: 0x8004d00a
Source : Microsoft OLE DB Provider for SQL Server
Description: New transaction cannot enlist in the specified transaction
SqlState : (null)
HelpFile : (null)