Search code examples
sql-serveroracle-databaselinked-server

Linked Server from x64 sql server to x64 Oracle

I am having a sql server 2005 x64 SP2 server (9.00.5069.00 (X64)) on Windows 2003 server (Service Pack 2)

I would like to create a linked server from this server to an Oracle server which is running in x64 bit machine. I do have x86 Oracle client installed. Do I need to have x64 Oracle client also?

Solution

  • To create a linked server on a 64-bit SQL Server you will need a 64-bit driver to use for your destination.

    32-bit drivers cannot be used for linked servers on a 64-bit SQL Server.