June 16, 2003 at 10:58 am
The following statement:
BEGIN TRAN
UPDATE name_table
SET
....
....
FROM name_server.name_db.dbo.name_table
ROLLBACK TRAN
(where name_server is my local machine)
Return this message:
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. ]
Why?? I don't understand
Help me Please
Thanks!!
June 16, 2003 at 11:13 am
Is MSDTC service running?
Are you connecting from SQL Server to SQL Server or other RDBMS is involved? If so, OLEDB provider maynot support updates via distributed queries.
What happens if you replace that UPDATE with a distributed SELECT (join tables from different servers together)? If it works, check the driver's capabilities.
June 17, 2003 at 1:15 am
Yes, MS DTC is running !
I execute the statement with Query Analyzer.
In the Query Analyzer, I'm connect with my local machine.
I execute the query on my local SQL Server!
I don't understand
Help me
Thanks
June 17, 2003 at 12:33 pm
What are you doing on the application side to manage your transactions?
June 17, 2003 at 1:01 pm
How many SQL Servers are participating the destributed transaction? Hvae you already setup linked server?
June 17, 2003 at 3:50 pm
Had a similar error, and so used the following code:
set xact_abort on
this will allow nested trans which the DT requries. After you have performed the DT then:
set xact_abort off
Hope this helps.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply