x

Problem updating table on linked server.

Hi,

Please help me with below scenario,

I am not getting any error while update a table that is on diferent server. but when I use Begin Tran I get below mentioned error.

"OLE DB provider "SQLNCLI" for linked server "192.168.10.115" returned message "The partner transaction manager has disabled its support for remote/network transactions.". Msg 7391, Level 16, State 2, Line 2 The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "192.168.11.103" was unable to begin a distributed transaction. "

My update statement is as

BEGIN TRAN
       update IB  
       set 
       IB.status = A.status
       from [192.168.11.103].Testdb.dbo.emp1 IB , emp2 A 
       where IB.eid = A.eid 
       and IB.form_no = A.form_no 

IF @@ERROR <> 0      
       BEGIN      
         ROLLBACK TRANSACTION      
         return -1      
       END
       ELSE
       BEGIN  
COMMIT TRANSACTION 
END
more ▼

asked May 14, 2012 at 05:24 AM in Default

innovator gravatar image

innovator
335 15 15 17

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Things to check:

  • DTC / Distributed Transaction Coordinator is running on both servers
  • Check that Network DTC access is allowed.

See [here][1] for more.

[1]: http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/7172223f-acbe-4472-8cdf-feec80fd2e64
more ▼

answered May 14, 2012 at 07:50 AM

ThomasRushton gravatar image

ThomasRushton ♦
33.8k 18 20 44

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x107

asked: May 14, 2012 at 05:24 AM

Seen: 1256 times

Last Updated: May 14, 2012 at 09:03 AM