• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 421
  • Last Modified:

ASP, Com+ Getting Distributed Transaction Error

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
Source: PORBusiness.clsBusCreate.createLocks
Description: [Microsoft][ODBC SQL Server Driver]Distributed transaction error

Does anyone have any suggestions?
It is a fairly important app that is used daily.

  • 2
1 Solution
gspronychAuthor Commented:
I've added the project to a VB app and tested the procedures.
The update procedures run successfully from the project source, including the createlocks method.

I've rebuilt the .DLL but still the same problem.
The problem seems to be somewhere in MTS.
gspronychAuthor Commented:
I couldn't find anything on the Internet, most people probably don't deploy ASP and Com+ projects on Win2k3.
so I made the costly call to M$.

So here is the resolution.
The problem is that DTC is disabled by default when installing Com+ on Win2k3.
To enabled DTC;
open Component Services
Expand the tree to display 'My Computer'
Right click on My Computer, select properties
Click the MSDTC tab
Click Security Configuration button
Put check boxes in the following fields
- Network DTC Access
- Network Administration
- Network Transactions

Say OK on the buttons and reboot, you'll be good to go.
Question answered by asker or dialog valuable.
Closed, 500 points refunded.
ee_ai_construct (replacement part #xm34)
Community Support Admin
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now