Error 7302 : Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server : (Doc ID 1362347.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Provider for OLE DB - Version 10.2.0.4.0 and later
Information in this document applies to any platform.
Microsoft SQL Server 2008

***Checked for relevance on 17-Mar-2017***


Symptoms

Creating a Linked Server using 64 bit OraOLEDB and Micrsoft SQL Server 2008 Management Studio 64 bit
fails when testing the connection with

TITLE: Microsoft SQL Server Management Studio
------------------------------
The test connection to the linked server failed.
------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server "ORCL". (Microsoft SQL Server, Error: 7302)

 

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