Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
2PC transaction replication problem
Message
De
22/08/2004 00:31:51
Km Kwun
Eastop Consultants Limited
Nt, Hong Kong
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Réplication
Titre:
2PC transaction replication problem
Divers
Thread ID:
00935265
Message ID:
00935265
Vues:
59
I created a 2PC transaction replication on a simple database for testing. Changes in the publisher are successfully replicated to the subscriber. However, when changes are made to the subscriber, the following error message is popped up (while trying to leave the edit row in Open Table | Return All Rows of the Enterprise Manager):

Another user has modified the contents of this table or view; the database row you are modifying no longer exists in the database. Database error: '[Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: New transaction cannont enlist in the specified transaction coordinator]....... The operation could not be performed because the OLE DB provider 'SQKOLEDB' was unable to begin a distributed transaction'


Could somebody help to solve the problem?

Thanks in advance.
KM
Répondre
Fil
Voir

Click here to load this message in the networking platform