Solved

ASP, Com+ Getting Distributed Transaction Error

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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

The purpose of this article is to demonstrate how we can use conditional statements using Python.
A short article about problems I had with the new location API and permissions in Marshmallow
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
The goal of the video will be to teach the user the concept of local variables and scope. An example of a locally defined variable will be given as well as an explanation of what scope is in C++. The local variable and concept of scope will be relat…

760 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now