Creating connection to Oracle server and fetch data

• Dhruva_51

  SSChampion

  Points: 10521

  More actions

  June 7, 2012 at 11:37 am

  #257299

  Hi,

  I am looking to pull the data from Oracle 10g server into SQL Server 2008 R2/windows 2008 R2 64bit OS.

  Can any one suggest me what drivers need to be installed on windows server to create a linked server and the steps to import data from oracle.

  Thanks.

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  June 7, 2012 at 3:43 pm

  #1498432

  You'll need the oracle client. You can find it here.

  -- Gianluca Sartori

• Jo Pattyn

  SSC-Dedicated

  Points: 32350

  More actions

  June 8, 2012 at 3:57 pm

  #1498966

  Working with Oracle subforum: Driver mania