Post reply

LINKED SERVERS - ORACLE

  • September 27, 2006 at 9:32 pm

    #169835

    Hi there,

     

    I have SQL Server 2005 running on a 64-bit environment. I am migrating SQL 2000 databases/packages/jobs, etc. to the new server and experiencing issues with ORACLE linked servers (as 64 MS OLE DB provider for Oracle is not yet available).  Does anyone have any suggestions to work around the problem?

     

    Thank you!

     

  • October 2, 2006 at 8:10 am

    #663635

    I dont know if this will work, but worth a few minutes of research.

    What about setting up an ODBC driver and map it to the Oracle Instance.  Then use sp_linkserver to add the named driver to the linked server list.  I dont know how to get the link server to recognize an odbc driver map, but may be worth a try? 

    Just an idea, HOPE it works, or you find a better solution

    Eric

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

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