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


The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft OLE DB Provider for Oracle 2.0
  • Microsoft OLE DB Provider for Oracle 2.1
  • Microsoft OLE DB Provider for Oracle 2.5
  • Microsoft OLE DB Provider for Oracle 2.6
  • Microsoft SQL Server 2000 (all editions)
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.
Modification Type:MajorLast Reviewed:5/13/2004
Keywords:kbDatabase kbOracle kbprb kbProvider KB220915 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.