Linked server to Oracle

From: James (james_at_silverglobe.com)
Date: 08/23/04 

Date: Mon, 23 Aug 2004 10:10:22 -0700

Hi, I am developing DTS that extract data from Oracle via
Linked server. I'm using MS OLE DB for Oracle.
The following error message prompted when I query to
selected tables (12 tables out of 40+ tables) in Oracle.

Server: Msg 7317, Level 16, State 1, Line 1 OLE DB
provider 'MSDAORA' returned an invalid schema definition.
OLE DB error trace [Non-interface error: OLE/DB provider
returned an invalid schema definition.].

Relevant Pages

  • Re: Oracle Linked Servers
    ... To use distributed transactions with the Oracle OLE DB Provider in your ... I created a blank database in sql server ...
    (microsoft.public.sqlserver.server)
  • LInked server to Oracle
    ... I'm using MS OLE DB for Oracle. ... provider 'MSDAORA' returned an invalid schema definition. ...
    (microsoft.public.sqlserver.connect)
  • Linked Server to Oracle
    ... I'm using MS OLE DB for Oracle. ... provider 'MSDAORA' returned an invalid schema definition. ...
    (microsoft.public.sqlserver.tools)
  • Linked server to Oracle
    ... I'm using MS OLE DB for Oracle. ... provider 'MSDAORA' returned an invalid schema definition. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: MDAC and Oracle9
    ... We have tried Oracle's native driver, the MS OLE DB driver for Oracle ... and the MS OLE DB Driver for ODBC Drivers using either the Microsoft ... We are getting error messages like this from W2K Server SQL Server ...
    (microsoft.public.sqlserver.server)