Post reply

Linked Server in 64 bit environment using MS OLE DB Provider for Oracle

  • May 2, 2008 at 2:19 am

    #189841

    Hi

    I am using LinkedServer to migrate data from Oracle 8.0 to SQL Server 2005. I am using MS OLE DB Provider for Oracle as the provider for Linked Server. In our development environment both SQL server and Oracle are 32 bit and migration is working fine.

    Now, in our production environment, Oracle is 32 bit but SQL Server will be 64 bit. In that scenario MS OLE DB Provider for Oracle will work or not ?

    If it doesn't work, then what can be done to make the LinkedServer work other than using Oracle provided OLE DB ?

    Kindly suggest its urgent.........

    Regards

  • May 22, 2008 at 7:28 am

    #819120

    There is no 64 bit Microsoft OLE DB Provider for Oracle. You have to use the Oracle OLE DB Provider. You can get that from installing ODAC on your server.

    http://www.oracle.com/technology/software/tech/windows/odpnet/index.html

  • May 22, 2008 at 8:52 pm

    #819469

    Thanks James

    I have an another query will Oracle OLE DB Provider works with 32 bit Oracle and 64 bit SQL Server environment. And since we are have Oracle 8.0, so in this regard do we have to install a specfic version of ODAC or anyone will do ?

    Thanks

  • May 23, 2008 at 8:15 am

    #819699

    That is a good question. I have the Oracle 10g ODAC install on my 64 bit SQL Server. I use it against an Oracle 9 database. I haven't tried against an Oracle 8 database to know if the 10g driver will work against it. Hopefully someone else on this board has tried that combination.

Viewing 4 posts - 1 through 3 (of 3 total)

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