When I try to update a table on my local server by
referring to another table in the the linked server I get
a message "Server: Msg 7391, Level 16, State 1, Line 1
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]."
Any ideas would be appreciated as I am running short of
time.
Regards,
VenugopalVenugopal,
Is the Distributed Transaction Coordinator running? On both servers? And
is it configured according to:
http://support.microsoft.com/defaul...kb;en-us;329332
A discussion of linked servers can be found in the article "Linked Servers
and Distributed Transactions"
http://tinyurl.com/2xnsv
Russell Fields
"Venugopal" <vemuriv@.hotmail.com> wrote in message
news:9e1c01c3eac1$61eb1590$a601280a@.phx.gbl...
quote:
> Hi,
> When I try to update a table on my local server by
> referring to another table in the the linked server I get
> a message "Server: Msg 7391, Level 16, State 1, Line 1
> 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]."
> Any ideas would be appreciated as I am running short of
> time.
> Regards,
> Venugopal
No comments:
Post a Comment