Linked server to Oracle

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

From: Yaheya Quazi (yquazi_at_ucmerced.edu)
Date: 07/08/04 

Date: Thu, 8 Jul 2004 15:10:12 -0700

I have setup a linked server to an oracle server.
Everything works fine but when I try to run queries as
below

select * from banner.UCM_DEV.BANINST1.TZVIDEN

I get the following error...

Server: Msg 7312, Level 16, State 1, Line 1
Invalid use of schema and/or catalog for OLE DB
provider 'MSDAORA'. A four-part name was supplied, but
the provider does not expose the necessary interfaces to
use a catalog and/or schema.
OLE DB error trace [Non-interface error].

In the above example
banner = linked server name
ucm_dev = is the database name
baninst1 = owner of the object
tzviden = view name

However, the following query works ..
select * from openquery(banner, 'select * from tzviden')

Relevant Pages

  • Linked server to as400 - for the love of god please help.
    ... i'm trying to setup a linked server between SQL Server and an AS400/DB2/IBM ... OLE DB provider 'MSDASQL' reported an error. ... OLE DB error trace [OLE/DB Provider 'IBMDA400' IColumnsInfo::MapColumnIDs ...
    (microsoft.public.sqlserver.server)
  • Re: Linked server from SQL Server to Access db on network share?
    ... What it looks like is this: SQL can create a linked server to a file on a remote share, but you can't query against it using Query Analyzer from any system other than the one hosting SQL... ... EXEC sp_tables_ex 'OLDSQL' ... OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. ...
    (microsoft.public.sqlserver.msde)
  • Re: Determining Fully Qualified Name for Linked Servers
    ... provider and the ODBC driver to support the same functions. ... >If I run it for the Linked Server configured with the Foxpro driver I ... >Catalog: NULL ... >Invalid schema or catalog specified for provider 'MSDASQL'. ...
    (microsoft.public.sqlserver.connect)
  • Re: Cant edit Linked Server General Properties after saving
    ... OLE DB Provider for Oracle. ... Server dialog after creating the Linked Server the General Properties ...
    (comp.databases.ms-sqlserver)
  • OLE DB Provider for ODBC and Oracle
    ... I created a linked server for MS SQL Server 2005 Express to an Oracle ... database using the OLE DB Provider for ODBC. ... I'm using the OLE DB Provider for ODBC instead of the Oracle OLE DB ...
    (comp.databases.ms-sqlserver)