Oracle Provider for OLE DB Does Not Show Up In List Of SQL Server Linked Server Providers

(Doc ID 1375755.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Developer Tools for Visual Studio .NET - Version 11.2.0.2 and later
Microsoft Windows x64 (64-bit)
Microsoft Windows x64 (64-bit) - Version: 2008 R2
***Checked for relevance on 21-Oct-2013***

Symptoms

You installed the following ODAC software on Windows 2008 R2

     64-bit ODAC 11.2 Release 3 (11.2.0.2.1) for Windows x64

using a command similar to the following:

C:\> install.bat all C:\Oracle ODAC


But, when you look in SQL Server's list of Providers for the Linked Server, the Oracle Provider for OLE DB does not show up.

If you test the Oracle Provider for OLE DB using a UDL file, you do not see the Oracle Provider for OLE DB in the list (see <Note 280028.1> for more information).

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