dotnet component services:
I am using Enterprise Services Serviced Components to handle database
transactions on a SQL Server 2000 database running on a Windows 2003
Server operating system. My web application which is calling my
serviced component is on a different server than my database. I am
using Required transactions with [AutoComplete].
I have read most of the postings on this subject. Most of the
solutions say that you just have to enable Network Transactions in
your Component Services -> My Computer -> Properties. However, I have
done this on both servers - the one running my application and the one
that has my database. I have restarted all services and even rebooted
both machines. This does not seem to work for me.
I have even downloaded the Microsoft DTCPing.exe and tested it from
both servers. All 3 tests pass - the ping, the RPC call and the
binding all succeed. However I am still getting the following error:
------------------------------------------------------------------------------
The transaction has already been implicitly or explicitly committed or
aborted
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException: The
transaction has already been implicitly or explicitly committed or
aborted
------------------------------------------------------------------------------
I have also tried playing around with the SQL Server database ->
properties -> Connection tabs. I tried selecting enable "implicit
transactions" and "enable distributed transactions (MTS)", and it
still does not work. These are problems that we are having with our
test server and test database server.
The weird thing is that I got the same errors on my local server when
I tried connecting to another database on another server than my local
box. However, I started changing the SQL Server database ->
properties -> implicit and distributed transaction check boxes and it
started working. But after it started working I restored it back to
the original settings and it still works locally.
The hard thing is that I can't seem to duplicate the same problem on
