Hi,

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:

<%@TRANSACTION=REQUIRED%>

and for commiting or aborting the transactions I use
ObjectContext.SetComplete
or
ObjectContext.SetAbort

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.

Sorin