Developer Forum

Hi,

Could someone please help me with the following problem.
I've been busy with this one for about 2 weeks and getting desperate now.

I want to do a distributed transaction via a linked server.
This is the query:

SET XACT_ABORT ON
BEGIN DISTRIBUTED TRANSACTION
update table1
set name = 'MachineA'
where id = 1

insert into [MACHINEB\TEST].cihatdb.dbo.table2
values (2, 'MachineB')
COMMIT
GO

This is the result:

(1 row(s) affected)

Server: Msg 7391, Level 16, State 1, Line 7
The operation could not be performed because the OLE DB provider 'SQLOLEDB'
was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the
specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d00a].

My Configuration:

Machine A:
Windows 2003 Enterprise Edition
SQL Server 2000 Enterprise edition version 8.00.0818 (SP3A + KB815495)
MDAC 2.8 + MS04-003
DTC is enabled on this server as described in
http://www.yqcomputer.com/
IP Adress: 192.168.2.10 255.255.0.0
No firewall, no domain
Name resolving trough DNS Server

Machine B:
Windows 2003 Enterprise Edition
SQL Server 2000 Enterprise edition version 8.00.0818 (SP3A + KB815495)
MDAC 2.8 + MS04-003
DTC is enabled on this server as described in
http://www.yqcomputer.com/
IP Adress: 192.168.2.11 255.255.0.0
No firewall, no domain
Name resolving trough DNS Server

Regards,

Cihat
DBA