ASP, Com+ Getting Distributed Transaction Error
Posted on 2004-10-13
One of my servers died which runs an ASP application using Com+ (n-teir).
It was running Windows 2000 Server, SQL server was on another server.
So, 2 years later I'm trying to remember how to setup this application.
I have setup IIS, and my Com+ components.
Com+ runs as a Domain account, has local admin rights, and db owner rights on the SQL server.
The app uses a System DSN called 'EPOR' that points to the SQL server.
The application runs fine for any of the components that select data (components with 'Select' statements).
But once a component that does an 'update' statement, the component fails.
My application returns
Error Number: -2147168246
Description: [Microsoft][ODBC SQL Server Driver]Distributed transaction error
Does anyone have any suggestions?
It is a fairly important app that is used daily.