We have created linked server between SQL Server7 and Oracler8 using OLEDB Provider thro MS SQL Server Enterprise Manager. While applying the following statements on my SQL Query Analyser the below error is coming. Please let me know the soultion.
Statements:
set REMOTE_PROC_TRANSACTIONS On
set XACT_ABORT ON
BEGIN DISTRIBUTED TRAN
select * from LnkServerNAme..LoginName.TableName
Commit TRAN
Error:
Server: Msg 7391, Level 16, State 1, Line 1
The operation could not be performed because the OLE DB provider ‘MSDAORA’ does not support distributed transactions.
