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

Tech-Archive recommends: Fix windows errors by optimizing your registry

arch
Date: 10/23/04 

Date: Sun, 24 Oct 2004 00:36:55 +0800

None of the stuff in that article seems to help. Same error message occurs.

"John Bell" <jbellnewsposts@hotmail.com> wrote in message
news:417a46c7$0$12657$afc38c87@news.easynet.co.uk...
> 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?
>>
>>
>
>

Relevant Pages

  • Re: Newbie problem: Saving a view from a linked server wont work
    ... Same error message occurs. ... >> could not be performed because the OLE DB provider 'MSDAORA' was unable ...
    (microsoft.public.sqlserver.programming)
  • Oracle linked server problem
    ... I am getting the following error message ... OLE DB provider 'MSDAORA' reported an error. ... Executing it this way works just fine. ...
    (microsoft.public.sqlserver.programming)
  • Re: Can Outlook Express be uninstalled?
    ... "PA Bear" wrote: ... Can you tell us the error message that you are getting. ... with your email account?Make sure that any Anti Virus email scanning is ... My provider, Cox cable, is ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: IIf dilemma
    ... John - Thank you so much...I did not receive an error message w/this syntax!! ... When I tried to run the report, ...
    (microsoft.public.access.queries)
  • Re: Unable to send emails - common issue!!
    ... Is Tiscali your Internet connection provider as well as your mail provider? ... That error message typically happens when the two providers are different. ... I have been using the same laptop for the past year, ...
    (microsoft.public.windows.vista.mail)