Microsoft KB Archive/277002

= PRB: Distributed Query Against Oracle 8.x Fails =

Article ID: 277002

Article Last Modified on 10/15/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q277002



SYMPTOMS
After you install Oracle 8.x client software on a SQL Server 7.0 or SQL Server 2000 server, and you create a linked server or DTS connection to an Oracle server, you receive the following error message when you try to query the Oracle linked server:

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

OLE DB provider 'MSDAORA' reported an error.

[OLE/DB provider returned message: Oracle 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 later client software installation.



CAUSE
This problem happens when the computer is not restarted after installing Oracle client software.



RESOLUTION
After installing Oracle 8.x client software on the server, restart the server.



Steps to Reproduce Behavior
 Install SQL Server 7.0 or SQL Server 2000 (this will install Microsoft Data Access Components [MDAC] also). Install Oracle 8.x client software. Test the access to the Oracle server by using SQL Plus. It should be working fine before you continue.  Using SQL Server Query Analyzer, create a linked server to the Oracle server by using the sp_addlinkedserver stored procedure: sp_addlinkedserver 'testname','Oracle','MSDAORA','oracleservername'   Using SQL Server Query Analyzer, try to run a query against the Oracle server by using SELECT * FROM OPENQUERY(...): SELECT * FROM OPENQUERY(testname,'select * from schema.table;') The error specified in the &quot;Symptoms&quot; section of this article will be returned. 

The third-party products that are discussed in this article 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: kbprb KB277002

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.