Create LinkServer between Oracle and SQL Server

• Fallen Angel

  Ten Centuries

  Points: 1128

  More actions

  May 14, 2004 at 9:19 am

  #65898

  How do you create a linkserver between Oracle and SQL server?

  I did this.

  sp_addlinkedserver @server = 'Oracle', @provider = 'MSDAORA'

  It returned '(null)' is an invalid product name.

  I want to access Oracle in a stored procedure that is why I need to create a link server between Oracle and SQL Server.

  Thanks

  

   

   

   

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  May 14, 2004 at 10:06 am

  #506517

  You should also add the @srvproduct = 'Oracle' parameter.

• neder

  SSC Eights!

  Points: 888

  More actions

  May 14, 2004 at 12:30 pm

  #506528

  1. install oracle client in the server where your sql server is

  2. configure oracle client

  3. set up the linked server (if you cannot set it up using sp_???, use the EM. It works)

   

   

   

• Fallen Angel

  Ten Centuries

  Points: 1128

  More actions

  May 17, 2004 at 8:05 am

  #506656

  Thanks