Microsoft KB Archive/220915

From BetaArchive Wiki
Knowledge Base


PRB: SQL Distributed Query with Oracle requires Oracle client and networking components

Article ID: 220915

Article Last Modified on 5/13/2004



APPLIES TO

  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft OLE DB Provider for Oracle Server 1.0
  • Microsoft OLE DB Provider for Oracle Server 1.0
  • Microsoft OLE DB Provider for Oracle Server 1.0
  • Microsoft OLE DB Provider for Oracle Server 1.0
  • Microsoft SQL Server 2000 Standard Edition



This article was previously published under Q220915

SYMPTOMS

When you try to use a SQL 7.0 linked server by using the Microsoft OLE DB Provider for Oracle, you may receive the following error message:

Server: Msg 7399, Level 16, State 1, Line 1

OLE DB provider 'MSDAORA' reported an error.

[OLE/DB provider returned message: The Oracle(tm) client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 (or greater) client software installation.

You will be unable to use this provider until these components have been installed.]

CAUSE

The error occurs because the Oracle client and networking components are not installed. The computer that is running SQL 7.0 requires the Oracle client and networking components to use MS Oracle provider to connect to an Oracle server.

WORKAROUND

If you are on a SQL Server cluster, you must install Oracle client and networking components on each of the nodes (or computers) that are part of the cluster. The Oracle client software (SQL*Net) is manufactured by Oracle Corporation. This software can be obtained only from Oracle Corporation.

MORE INFORMATION

With Microsoft SQL Server 7.0, you can perform queries against OLE DB providers. You do this by using the OpenQuery or OpenRowset Transact-SQL functions or by using a query with four-part names including a linked-server name. For example:

sp_addlinkedserver 'mylinkedserver', 'product_name', 'myoledbprovider', 'data_source','location', 'provider_string', 'catalog'

SELECT * FROM OPENQUERY(mylinkedserver, 'select * from table1')
                

SQL Server 7.0 installs Microsoft OLE DB Provider for Oracle. To query a local or remote Oracle server database from SQL Server query that uses the Microsoft OLE DB Provider for Oracle, you must install Oracle client and networking components on the computer that is running SQL Server.

For Transact-SQL code examples on setting up and using distributed queries with an Oracle server search on "Microsoft OLE DB Provider for Oracle" in the index of the SQL Server 7.0 Books Online.

For information about how to contact Oracle, click the appropriate article number in the following list to view the article in the Microsoft Knowledge Base:

65416 Hardware and Software Third-Party Vendor Contact List, A-K

60781 Hardware and Software Third-Party Vendor Contact List, L-P

60782 Hardware and Software Third-Party Vendor Contact List, Q-Z




The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

Keywords: kboracle kbprovider kbdatabase kbprb KB220915