We are trying to replicate from Oracle 11G to SQL Server 2008R2. The OS is windows server 2008R2 64bit. I installed the oracle 11G 64bit client. And then restarted the SQL Server services. I still can't see the oracle provider under LinkedServer---->Providers
within Sql server management studio. So now I am thinking of uninstalling the oracle 64bit client and instead install oracle 32bit client. Before doing that I want to check with you all. Any ideas will be greatly appreciated. Thanks.
View Complete Post