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

Article translations Article translations
Article ID: 220915 - View products that this article applies to.
This article was previously published under Q220915
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

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 more information about hardware and software vendor contact information, visit the following Microsoft Web site:
http://support.microsoft.com/gp/vendors
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.

Properties

Article ID: 220915 - Last Review: February 21, 2014 - Revision: 5.3
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
Keywords: 
kbnosurvey kbarchive kbdatabase kboracle kbprb kbprovider KB220915

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com