PRB: SQL Distributed Query with Oracle Needs Oracle Client and Networking Components

ID: Q220915

The information in this article applies to:

Microsoft SQL Server version 7.0
Microsoft OLE DB Provider for Oracle, version 2.0

SYMPTOMS

Attempting to use a SQL 7.0 linked server using the Microsoft OLE DB Provider for Oracle, may result in 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 is cause by not having the Oracle client and networking components installed. The SQL 7.0 machine needs the Oracle client and networking components in order to use MS Oracle provider to connect to an Oracle server.

WORKAROUND

You need to install Oracle client and networking components on the SQL 7.0 machine. The Oracle client software (SQL*Net) is manufactured by Oracle Corporation. This software can be obtained only from Oracle Corporation.

MORE INFORMATION

Microsoft SQL Server version 7.0 provides the ability to perform queries against OLE DB providers. This is done 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. You need to install Oracle client and networking components on the SQL Server machine in order to query a local or remote Oracle server database from SQL Server query using Microsoft OLE DB Provider for Oracle.

For T-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, please query in the Knowledge Base for one or more of the following articles:

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

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

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

The third-party products discussed here are manufactured by vendors independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability.

Additional query words:

Keywords : kbDatabase kbOLEDB kbOracle kbProvider kbSQLServ kbVC
Version : WINDOWS:2.0; winnt:7.0
Platform : WINDOWS winnt
Issue type : kbprb