Error Creating a SQL Server Linked Server with SQL Server Management Studio (SSMS)

(Doc ID 1422444.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Provider for OLE DB - Version 8.1.7.0 and later
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)
***Checked for relevance on 21-Oct-2013***

Symptoms

You have configured a SQL Server Linked Server with SQL Server Management Studio (SSMS) for any of the interfaces below:

and receive one of the following errors:


Oracle Provider for OLE DB Error Message

Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server "ORAOLEDB.
(Microsoft SQL Server, Error: 7302)





Microsoft OLE DB Provider for Oracle Error Message

Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "MSOLEDB". OLE DB provider "MSDAORA" for linked server "MSOLEDB" 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.

Provider is unable to function until these components are installed.".
(Microsoft SQL Server, Error: 7303)


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms