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