Last updated on JULY 05, 2017
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 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)
------------------------------
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