Distributed transactions between MSSQL and Oracle

From: kipnukdog kipnukdog_at_netscape.net>
Date: Tue, 20 Feb 2001 12:50:36 -0800
Message-ID: <t95m1fslt2252e@news.supernews.com>

Have a user trying to execute a distributed transaction between MSSQL Server 7.0 and Oracle 8, and she's receiving the following error message:

Server: Msg 7391, Level 16, State 1, Line 4 The operation could not be performed because the OLE DB provider 'MSDAORA' does not support distributed transactions. OLE DB error trace [OLE/DB Provider 'MSDAORA' ITransactionJoin::JoinTransaction returned 0x8004d01b].

The query is simple, and is the following:

SET XACT_ABORT ON BEGIN DISTRIBUTED TRAN
SELECT CUSTOMER_NAME from PRODDB..CUST.CUSTOMER COMMIT TRAN Any ideas on why this is failing?

Thanks. Received on Tue Feb 20 2001 - 14:50:36 CST