My Oracle Support Banner

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

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
References


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