Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

ASP, Com+ Getting Distributed Transaction Error

Posted on 2004-10-13
3
Medium Priority
?
419 Views
Last Modified: 2013-11-25
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.

Thanks
0
Comment
Question by:gspronych
  • 2
3 Comments
 
LVL 3

Author Comment

by:gspronych
ID: 12300729
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.
0
 
LVL 3

Author Comment

by:gspronych
ID: 12309260
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.
Cheers
0
 

Accepted Solution

by:
ee_ai_construct earned 0 total points
ID: 12311360
Question answered by asker or dialog valuable.
Closed, 500 points refunded.
ee_ai_construct (replacement part #xm34)
Community Support Admin
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Loops Section Overview

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question