access data from ORACLE Database?

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  January 30, 2012 at 12:08 am

  #255574

  Hi,

  I want access get it data from oracle database in SQL Server 2008 database server.

  In this cause need to install oracle client in SQL server machine then create linked server with oracle user id at sql server.

  Is it possible without oracle client can able to access data in sql server?

  thanks

  ananda

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  January 30, 2012 at 1:38 am

  #1439861

  If you want to set up a linked server you need the Oracle client.

  There's no way around it.

  -- Gianluca Sartori