Re: Distributed transactions between MSSQL and Oracle

Never mind about this....looks like distributed transactions are not allowed between MSSql Server and a linked Oracle DB.

"kipnukdog

> 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 - 15:03:20 CST