transacciones distribuidas

10/12/2003 - 21:25 por Rafe | Informe spam
saludos

trato de hacer una transaccion entre un servidor win 2003
standar edition y un win XP pro
con sql server standard ed. y personal ed. respectivamente

cuando hago un
begin tran
select * from servidorremoto.basedatos.dbo.tabla
commit tran

sale este error

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].
 

Leer las respuestas

#1 Gustavo Larriera [MVP]
11/12/2003 - 05:33 | Informe spam
Fijate en:

http://support.microsoft.com/defaul...-us;329332

saludos
gux

Gustavo Larriera, MSFT MVP-SQL
Uruguay LatAm

This message is provided "AS IS" with no warranties expressed or implied,
and confers no rights.


"Rafe" wrote in message
news:026c01c3bf5b$d009acd0$
saludos

trato de hacer una transaccion entre un servidor win 2003
standar edition y un win XP pro
con sql server standard ed. y personal ed. respectivamente

cuando hago un
begin tran
select * from servidorremoto.basedatos.dbo.tabla
commit tran

sale este error

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].

Preguntas similares