-
Distributed Transaction error
Hi all,
I encountered this problem when tried to perform a distributed transaction using link server. My aim was to connect 2 data base servers using TCP/IP and transfer data. I was able to run single queris using "linkserver.catelog. owner.table". But this message was shown when i tried to execute a stored procedure. The message was "The operation could not be performed since OLEDB provider SQLOLEDB doesn't support distributed transactions. [OLE/DB distributed transaction error]" The documentations about the distributed transactions showed that SQLOLEDB do support distributed transactions. Please forward your valueble suggestions.
Thanks in advance,
Sabu
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|