Discussion Locked

Distributed Transaction...

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

1 reply

by erikdr

Correct error. The Oracle driver apparently does not support a distributed transaction when encompassing other non-Oracle servers.

So you need a meta-manager which DOES support distributed transactions over multiple platforms. Which is quite a touchy subject in database tech. I'd recommend watching the following products, and focusing especially on what they do towards SQL and Oracle:
* MS Distributed Transaction Services (probably better on W2K than on NT)
* IBM Txseries/Encina for Windows

and other 'Transaction Processing Monitoring' tools - probably Oracle also has one, but that might have limitations towards SQL Server.

Hope this helps,

- The Netherlands

This discussion is closed to new replies.