Tuesday, February 14, 2012

Distributed Transaction

I am trying to access a table in another server and I keep getting this error msg.
'THE OLEDB provider was unable to begin a distributed transaction'
I have a linked server and I am using Microsoft OLE DB Provider for SQL Server.
Anyone can help?can you give an example as to the way you are trying to access the other table on the 'b' server?

What T-SQL statement are you trying to use?|||I was trying to INSERT. Does that only work for SELECT?!|||Basically i was trying to use the statement below where AP2K380 is my linked Server.

insert into AP2K380.asiapac702_test.dbo.tblCustServiceHistoryH dr

and I ran into an error saying that the SQLOLEDB was unable to being a distributed transaction.

Pls help...thanks a million!

No comments:

Post a Comment