Error 7302 : Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server :
(Doc ID 1362347.1)
Last updated on NOVEMBER 15, 2019
Applies to:
Oracle Provider for OLE DB - Version 10.2.0.4.0 and laterInformation in this document applies to any platform.
Microsoft SQL Server 2008
***Checked for relevance on 30-Dec-2018***
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)
------------------------------
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 |