Configuration:
Server-1: COM+ components installed on W2K3
Server-2: SQL 2000 Server SP3 installed on W2K3

We use an application that has its components on server-1 and accesses data
on server-2. Everything works fine when querying data (ex.customer
information) but when we try to save any modification (ex.address change) an
error pops up.

I ran the 'dtctester' and it came up with the following:
Executed: dtctester
DSN: database2
User Name: sa
Password: xxxx
tablename= #dtc30537
Creating Temp Table for Testing: #dtc30537
Warning: No Columns in Result Set From Executing: 'create table #dtc30537
(ival int)'
Initializing DTC
Beginning DTC Transaction
Enlisting Connection in Transaction
Error:
SQLSTATE=25S12,Native error=-2147168219,msg='[Microsoft][ODBC SQL Server
Driver]Distributed transaction error'
Error:
SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid
cursor state
Typical Errors in DTC Output When
a. Firewall Has Ports Closed
-OR-
b. Bad WINS/DNS entries
-OR-
c. Misconfigured network
-OR-
d. Misconfigured SQL Server machine that has multiple netcards.
Aborting DTC Transaction
Releasing DTC Interface Pointers
Successfully Released pTransaction Pointer.


Thanks for your input,
s.c.

Problem fixed.
I enabled DTC on server-2 (DB) as mentioned in the following article:
http://www.sqlmonster.com/Uwe/Forum....-dtctester-exe
//
Hi Dave,

Thanks for your post. If I understand correctly you got the following error
message when you tried and connect using an ODBC connection form within an
MTS/COM+ component.

Microsoft OLE DB Provider for ODBC Drivers error '8004d00a'
[Microsoft][ODBC SQL Server Driver]Distributed transaction error

Based on my research, by default, network DTC access is disabled on the
Windows Server 2003 products. When you do not enable network DTC access on
the server, applications can only use transactions that stay on the local
computer. Please try the suggestions in the following article and do not
forget to restart your computer after enabling network DTC access.

817064 HOW TO: Enable Network DTC Access in Windows Server 2003
http://support.microsoft.com/?id=817064
//


"SC@IS" <steve (AT) nospam (DOT) camp> wrote