In 64-bit SQL Server 2008 R2, I am trying to create a linked server to an Oracle 11g database. I have installed the 32-bit Oracle 11g Instant Client and set up tsnames.ora and sqlnet.ora in proper Oracle home directories.
In SQL Server management studio, under Server Objects - Linked Servers - Providers, I do not see the OraOLEDB.Oracle in the list. I've rebooted and re-installed the Instant Client. I stopped and started the SQL Server service. I even confirmed
that OraOLEDB.Oracle exists as one of the SQL Server providers in the registry.
There are full permissions on the directory where the Oracle Instant Client is installed.
Does anyone have any recommendations about how to get the OraOLEDB.Oracle to show up in the list of providers? I'm not sure why it would show up in the Registry but not in SQL Server Management Studio.
Wmholt SharePoint Developer
View Complete Post