Solved

ASP, Com+ Getting Distributed Transaction Error

Posted on 2004-10-13
3
410 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

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.
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
The viewer will learn how to clear a vector as well as how to detect empty vectors in C++.

830 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