RE: Linked server to Oracle

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

From: James (James_at_discussions.microsoft.com)
Date: 08/30/04 

Date: Mon, 30 Aug 2004 00:29:02 -0700

Hi, here's my spec.

Oracle server = Oracle Server 8i release 8.1.7.4

SQL Server which I need to establish a linked server connection=
OLE DB or Oracle version 2.71.9030
Oracle SQL Plus Release 9.2.0.1.0

Does this mean that I need to use the Oracle SQL client v 8?

I tried the latest MDAC with OLE DB for Oracle 2.8, it doesn't work as well.

rgrds,
James Gan HJ

""Mingqing Cheng [MSFT]"" wrote:

> Hi James,
>
> Thanks for using MSDN Managed Newsgroup!
> Thanks the perfect answer from Sue!
>
> From your descriptions, I understood you meet the error 7317 when using DTS
> push data from Oracle. Have I understood you? If there is anything I
> misunderstood, please feel free to let me know.
>
> Bbased on my knowledge, you may have encounter an known issue in MDAC. The
> provider asks Oracle for a list of the column names in an Oracle index. For
> most indexes the internal name Oracle has for the index columns is the same
> as the actual column names. However, if the Oracle index is descending or
> is a function_based index, it does not return actual column names, it
> returns a generated name of some sort. Our Oracle provider does not
> distinguish between the results and it tries to use the returned values as
> actual column names, resulting in the "invalid schema definition". I cannot
> tell for sure from the internal documentation, but this behavior may have
> changed between versions on the Oracle side. Our Oracle provider has not
> been updated recently, to take advantage of newer Oracle functionality you
> need to use Oracle's provider instead of ours.
>
> You'd better use four-part name syntax correct this issue. Use the query
> like this
>
> SELECT * FROM OPENQUERY(WACRPPRD, 'select
> LAST_NAME,FIRST_NAME,PH_NUM,PAGER,DIRECT_PHONE,EXTENSION,EMAIL_ADDR,TITLE,DE
> PT_DESC,
> OFFICE_SITE,SUPV_PH_NUM from PH.QBS_PH_PEOPLE where PH_NUM is not null and
> ACTIVE_FLAG = ''Y'' order by QPE_EMP_NUM')
>
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
>
> Sincerely yours,
>
> Mingqing Cheng
> Microsoft Developer Community Support
> ---------------------------------------------------------------
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>
>
>
>
>
>
>
>

Relevant Pages

  • Re: Local Access table in Oracle query
    ... When you have Oracle SQL and need to use data in a local Access table as ... then incorporate that into the bigger Oracle string. ...
    (comp.databases.ms-access)
  • Re: Oracle SQL Developer && LDAP Connection
    ... Generated by Oracle configuration tools. ... The problem lies in that I can't create LDAP connection in Oracle SQL ... The version of Oracle SQL developer is 1.5.1.54.40. ...
    (comp.databases.oracle.tools)
  • RE: Linked server to Oracle
    ... Thanks for using MSDN Managed Newsgroup! ... provider asks Oracle for a list of the column names in an Oracle index. ... Our Oracle provider does not ...
    (microsoft.public.sqlserver.connect)
  • Re: Linked server to Oracle
    ... you don't necessarily need to go back to the v 8 Client. ... What task are you using and how are you querying the Oracle ... >> provider asks Oracle for a list of the column names in an Oracle index. ... Our Oracle provider does not ...
    (microsoft.public.sqlserver.connect)
  • Re: Question on Decode Versus Case
    ... With Grouping Group Values) in which he uses the decode function. ... In my reference book I'm using for my Oracle SQL, and now some of the PL/SQL I am learning on my own, the author stated "Oracle is planning to drop the DECODE function in future releases and to replace the function with the ...
    (comp.databases.oracle.server)