Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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:27 CST