Re: linkserver error
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 03/31/04
- Next message: Tom Furness: "Moving SQL to a new server."
- Previous message: Aaron Prohaska: "Re: Cascade Delete not working"
- In reply to: SQL Apprentice: "Re: linkserver error"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 31 Mar 2004 11:35:09 -0700
Because of a difference in the APIs, column bindings when
you are using Openquery. Openquery takes the SQL statement
and sends it directly to Oracle where it's parsed, executed
on the Oracle server and then just the results are sent back
to the client. The client doesn't go through as much "work"
and doesn't have to go through as many of the data access
APIs, bindings to process an openquery statement.
-Sue
On Wed, 31 Mar 2004 09:52:11 -0800, "SQL Apprentice"
<mssqlworld@yahoo.com> wrote:
>FYI,
>
>It runs when using OPENQUERY but not straight from a select to the
>linkserver name
>
>Why???
>
>
>"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
>news:md9k60lq1kklthglkhkb5vvd7h85b66e7m@4ax.com...
>> Check the following article:
>> PRB: Distributed Queries Return Error 7356 with MSDAORA
>> http://support.microsoft.com/?id=251238
>>
>> -Sue
>>
>> On Tue, 30 Mar 2004 14:12:28 -0800, "SQL Apprentice"
>> <mssqlworld@yahoo.com> wrote:
>>
>> >Hello,
>> >
>> >I created a job that uses a linkserver to Oracle db for the past year.
>> >It ran fine until a few days ago when Oracle db schema changed.
>> >
>> >I modified my SQL schema to be the same as theirs but I am still getting
>an
>> >error.
>> >I ran the following on Query Analyzer.
>> >
>> >SELECT *
>> >FROM OracleServer..TableName
>> >
>> >Server: Msg 7356, Level 16, State 1, Line 1
>> >OLE DB provider 'MSDAORA' supplied inconsistent metadata for a column.
>> >Metadata information was changed at execution time.
>> >OLE DB error trace [Non-interface error: Column 'Col1' (compile-time
>> >ordinal 13) of object '"OraDB"."TableName"' was reported to have a DBTYPE
>of
>> >130 at compile time and 5 at run time].
>> >
>> >However, when I user OpenQuery...Then it worked.
>> >SELECT *
>> >FROM OPENQUERY(OracleServer, 'SELECT * FROM OraDB.TableName')
>> >
>> >Can you give me some advice on how to fix this problem...
>> >I have SQL 2000 Ent on W2K Server with latest service packs.
>> >
>> >thank again for your help.
>> >
>> >
>> >
>> >
>> >
>>
>
- Next message: Tom Furness: "Moving SQL to a new server."
- Previous message: Aaron Prohaska: "Re: Cascade Delete not working"
- In reply to: SQL Apprentice: "Re: linkserver error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
