November 9, 2001 at 5:14 am
Hi all,
I hope someone can help.
I am setting up a system to replicate data from one database to another on 2 separate servers. The set-up using enterprise manager seemed to go fine and data replicates form the publisher to the subscriber without problem, however when the subscriber tries to update the publisher the following error occurs
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
the transaction attempted was a simple update on a single field on one table as below
update actor
set actor_name = 'tinky winky'
where actor_id = 54
The subscriber is set up for transactional replication with failover to merge replication.
Any ideas on what i have done wrong would be most welcome.
Thanks in advance
Matt Thompson
November 9, 2001 at 7:23 am
Sounds like your DTC isn't running.
Andy
Andy
November 9, 2001 at 8:11 am
Does seem that way, where would one turn it on?
November 9, 2001 at 8:13 am
just checked the DTC and it is running at both ends, any other ideas?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply