Dear friends ,i am facing a criticalerror,pls help me out :-
My MTS component(developed using ATL and using ADO to access 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 rarely.Pls tell what can be its reason and how to fix it .
regards
akshay
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:\ProgramFiles\......mercury_wms.udl
ADO ERROR 1: 0x8004d00a
Source : Microsoft OLE DB Provider for SQL Server
Description: New transaction cannot enlist in the specified transaction coordinator.
SqlState : (null)
NativeError: 0x0
HelpFile : (null)
HelpContext: 0
ERROR: COM Exception in executeQuery() [DbKernel.cpp(171)]
ADO ERROR 1: 0x8004d00a
Source : Microsoft OLE DB Provider for SQL Server
Description: New transaction cannot enlist in the specified transaction coordinator.
SqlState : (null)
NativeError: 0x0 HelpFile : (null)
HelpContext: 0
ERROR: Error SQL : set transaction isolation level read committed;
INSERT INTO MRC_STOCK_DATA (STOCK_ITEM_GUID, WAREHOUSE_GUID,ITEM_ID,
UNIT_ID,TOTAL_RECEIVED,TOTAL_REJECTED, TOTAL_PICK_RESERVE,TOTAL_PICKED,
TOTAL_ADJUSTED,TOTAL_RETURNED,TOTAL_DISPOSED_OFF,TOTAL_PACKED,
TOTAL_SHIPPED,ON_HAND, ON_HOLD,TOTAL_EXCESS,ON_ORDER,ON_RESERVE,
CREATED_BY, LAST_MODIFIED_BY) Select newid(),WAREHOUSE_GUID,
'{B3CE6383-EE8A-4131-8F85-6C8EB4C994B3}','{6AA23C56-7A4F-11D2-84B0-0000F80
627E2}',0,0,0,0,0,0,0,0,0,0,0,0,0,0, 'eStore_User','eStore_User' From
Mrc_Warehouse [DbKernel.cpp(173)]
(3016,2828)2003/09/16 15:46:00.654 H:0337 W:10162176 P:4608000 ERROR: ADO
Error!- Catch Block [DalKernel.cpp(150)]
COM ERROR : 0x8004d00a
Meaning : IDispatch error #52746
Source : (null)
Description: (null)
ERROR: Generated BS error code: 0x3004009a, returned error code:0x800460ff [DalKernel.cpp(156)]