Re: UPDATE Statement Involving Tables in Different Databases

Mark's suggestion worked great when I ran it on a simple test, but I'm
having problems applying this methodology to my real (more complex)
application. I get the following error when running the script from
Query Analyzer:

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

Note that both databases reside on the same server and I checked
Distributed Transaction Coordinator (DTC) to make sure that it's
running. What else about this kind of distributed UPDATE statement
would cause such an error?

.

Relevant Pages

  • Distributed transaction on linked server.
    ... domain and Distributed Transaction Coordinator is running. ... I am receiving the following error message from a .NET windows service when ... [OLE/DB provider returned message: New transaction cannot enlist in the ...
    (microsoft.public.sqlserver.dts)
  • Linked Server on WinXP SP2
    ... This problem is something that occurs with WinXP SP2 and is ... run a distributed transaction against a linked server after you install ... was unable to begin a distributed transaction. ... OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ...
    (microsoft.public.sqlserver.programming)
  • Re: UPDATE Statement Involving Tables in Different Databases
    ... 'SQLOLEDB' was unable to begin a distributed transaction. ... OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ... If the databases are on the same instance of SQL Server, ...
    (comp.databases.ms-sqlserver)
  • Problem with distributed transaction via linked server
    ... I want to do a distributed transaction via a linked server. ... OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ... Name resolving trough DNS Server ...
    (microsoft.public.data.oledb)
  • Error 7391 on linked server during distibuted transaction
    ... I want to do a distributed transaction via a linked server. ... OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ... Name resolving trough DNS Server ...
    (microsoft.public.sqlserver.connect)