Solved

ASP, Com+ Getting Distributed Transaction Error

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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
The purpose of this article is to demonstrate how we can use conditional statements using Python.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
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…

770 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