Re: Newbie problem: Saving a view from a linked server won't work
From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 10/23/04
- Next message: Mzeeshan: "SQL Server 2000 issues with Windows 2003 Server."
- Previous message: John Bell: "Re: Newbie problem: Saving a view from a linked server won't work"
- In reply to: arch: "Newbie problem: Saving a view from a linked server won't work"
- Next in thread: Erland Sommarskog: "Re: Newbie problem: Saving a view from a linked server won't work"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 23 Oct 2004 12:57:48 +0100
Hi
Have you checked
http://support.microsoft.com/default.aspx?scid=kb;EN-US;280106
John
<arch> wrote in message news:417a42df$1@funnel.arach.net.au...
> 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 distributedtransaction.
>
> [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?
>
>
- Next message: Mzeeshan: "SQL Server 2000 issues with Windows 2003 Server."
- Previous message: John Bell: "Re: Newbie problem: Saving a view from a linked server won't work"
- In reply to: arch: "Newbie problem: Saving a view from a linked server won't work"
- Next in thread: Erland Sommarskog: "Re: Newbie problem: Saving a view from a linked server won't work"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
