PRB: Distributed Query Against Oracle 8.x Fails (277002)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
  • Microsoft SQL Server 7.0
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.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Install SQL Server 7.0 or SQL Server 2000 (this will install Microsoft Data Access Components [MDAC] also).
  2. 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.
  3. 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'
  4. 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 "Symptoms" 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.
Modification Type:MajorLast Reviewed:10/15/2003
Keywords:kbprb KB277002
©2003 Microsoft Corporation. All rights reserved.