Distributed Transaction Error

<i><b>Originally posted by : sabu (sabu_p@usa.net)</b></i><br />Hi all,<br /><br /> 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. <br /><br />Thanks in advance,<br />Sabu <br /><br />