My Oracle Support Banner

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

Last updated on NOVEMBER 18, 2019

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 27-Mar-2019***

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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.