Newbie problem: Saving a view from a linked server won't work

arch
Date: 10/23/04 

Date: Sat, 23 Oct 2004 19:51:00 +0800

Hi. I've created a linked server to Oracle 8i. I want to save a view as
follows:

SELECT *
FROM ORACLE8I..SCOTT.EMP EMP_1

>From SQL Query Analyser, this returns a nice set or records. Running this
from the view designer also returns a nice result. However, if I try to to
save the view, I get the following error message:

ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server] The operation
could not be performed because the OLE DB provider 'MSDAORA' was unable to
begin a distributed transaction.

[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB
Provider 'MSDAORA' ITransactionJoiJoin Transaction returned 0x8004d01b].

Anyone know what I'm doing wrong?

Relevant Pages

  • Re: ADO.NET and ODBC { CALL ..... } Syntax
    ... > Coonecting to Oracle 8i DB running on Unix ... > OleDB connection with provider as MSDAORA. ... > the same way as it works in ADO arena. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Distributed transactions
    ... With Oracle 9i, Oracle wants you to use the Oracle Services for MTS in ... instead of the old MTXOCI solution that was used by the MSDAORA ... OLE DB provider 'MSDAORA' reported an error. ...
    (microsoft.public.sqlserver.security)
  • OLE DB provider MSDAORA reported an error.(SQL Server 7399)
    ... OLE DB provider 'MSDAORA' reported an error. ... The error araises when quering the remote oracle database. ...
    (microsoft.public.sqlserver.server)
  • Error in distributed transaction with Oracle
    ... The operation could not be performed because the OLE DB provider 'MSDAORA' was unable to begin a distributed transaction. ... but the stored procedure (whitch access Oracle) even can't be saved SOMETIMES into the SQL database from Enterprise manager after edit. ...
    (microsoft.public.sqlserver.programming)
  • Newbie problem: Saving a view from a linked server wont work
    ... I've created a linked server to Oracle 8i. ... from the view designer also returns a nice result. ... Provider 'MSDAORA' ITransactionJoiJoin Transaction returned 0x8004d01b]. ...
    (microsoft.public.sqlserver.programming)