Hi,
I have a SQL Server 2005 on a windows 64 bit and planning to setup a linked server to an Oracle Database.
I installed the 64-bit Oracle 10g client on the SQL Server machine, now while trying to setup the linked server I figured out that there is no provider 'Microsoft OLE DB Provider for Oracle' in the drop down list which we used to setup in our dev system ( its a 32-bit machine ).
After reading many msdn forums, I came to know that Microsoft doesn't have a provider for Oracle for 64-bit and has to use Oracle provider 'Oracle OLE DB Provider'.
I used this provider to create the linked server, gave the login details and everything but it never finished and I ended up killing that process id.
Can anyone help me in setting the linked server.
Thank you in advance,
Sree