you could have a look into the functionality of the Oracle rather than the
MS OLE-DB driver, though my memory of the Oracle 8 version isn't the
happiest.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"kipnukdog <kipnukdog_at_netscape.net >" <"NO SPAM> wrote in message
news:t95mpcek9oc6e3_at_news.supernews.com...
> 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 Wed Feb 21 2001 - 03:14:46 CST
