var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Distributed transaction completed error.
I have an ASP application which uses a COM object to read/write/delete/update data from a SQL Server 2000 (SP3).
In the ASP page on the first line I have:
and for commiting or aborting the transactions I use
The application works fine but under heavy use it sometimes throws the error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.
The error code is -2147217900
If I do not use MS DTC in the ASP page, I don't get this error any more but also I don't have the transaction integrity (sometimes I have to update also some other database).
Any help would be greatly appreciated.