Re: Linked server to Oracle

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 08/24/04 

Date: Mon, 23 Aug 2004 18:58:28 -0600

One scenario where you can get the error is with data types
that aren't supported by the OLE DB provider or by SQL
Server.
Can you query the tables using just an Openquery in Query
Analyzer?
You would probably want to check the documentation for the
driver to determine what data types are supported. Also,
make sure you are using the latest provider, Oracle client.

-Sue

On Mon, 23 Aug 2004 10:10:22 -0700, "James"
<james@silverglobe.com> wrote:

>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: .NET data provider or OLEDB provider?
    ... >I don't see where you see a built-in query engine. ... >service provider, ... >OLE DB providers don't have to support SQL however, ... > SQL Server linked server, SQL Server can handle the queries. ...
    (microsoft.public.data.oledb)
  • How do I registry the OLE provider for a Exchange 2003 database
    ... I receive the following error when I try to query an Exchange database using ... Could not locate registry entry for OLE DB provider 'exoledb.DataSource.1'. ... How do I registry the OLE provider for a Exchange 2003database. ...
    (microsoft.public.exchange.connectivity)
  • Re: Zugriff auf Active Directory
    ... An error occurred while preparing a query for execution against OLE DB ... provider 'ADSDSOObject'. ... OLE DB error trace [OLE/DB Provider 'ADSDSOObject' ...
    (microsoft.public.de.sqlserver)
  • Re: Zugriff auf Active Directory
    ... FROM OPENQUERY(ADSI, ... An error occurred while preparing a query for execution against OLE DB ... OLE DB error trace [OLE/DB Provider 'ADSDSOObject' ...
    (microsoft.public.de.sqlserver)
  • Re: Finally which ORM tool?
    ... method used INSIDE the query is passed as the value immediately, ... That's also info not NEEDED to write correct queries on the ... Sequence and set aren't equal, true, but in this case, where linq ... to use the subquery train, I have to use joins, or rely on the provider ...
    (microsoft.public.dotnet.languages.csharp)