How to setup a linked server from SQL 2005 to Oracle for a 64 bit server

  • 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

  • http://www.mssqltips.com/tip.asp?tip=1433

    Alex S

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply