Error 7317 when Accessing Linked Oracle Server

From: Bill Manring (BillManring_at_discussions.microsoft.com)
Date: 12/29/04 

Date: Wed, 29 Dec 2004 10:31:03 -0800

I have a linked server to an Oracle 8i database. When I attempt to query the
Oracle tables I get the following error:

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.].

The problem is occurring at my customer's site. I have tried duplicating
their environment in my office, but I can not reporduce the problem.

I would appreciate any help you could offer. 

-- 
Thanks,
Bill Manring
Chief Software Architect
Wavefront Software, Inc.

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)
  • Oracle-DB an SQL-Server anbinden
    ... Hierfür habe ich auf dem SQL-Server einen Verbindungsserver über ... den OLE DB Provider 'MSDAORA' eingerichtet. ... [OLE/DB provider returned message: Oracle Client- und Netzwerkverbindung ...
    (microsoft.public.de.sqlserver)
  • RE: SQL 64 to Oracle Link
    ... Your Oracle Client is 10.2.0.1.0. ... would like to let you know that Mirosoft version OLE DB Provider for Oracle ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.connect)
  • Re: ora-00162: external dbid length greater ...
    ... Ms OLE DB Provider for Oracle ... Habe bisher rausbekommen, dass das irgendwas mit der DLL- ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • Re: Verbindunsserver
    ... > per Verbindungsserver greife ich auf eine ORACLE ... > MS OLE DB Provider for Oracle. ... > Der OLE DB-Provider 'MSDAORA' hat inkonsistente Metadaten ...
    (microsoft.public.de.sqlserver)