How to set up oracle 11g as linked server in sqlserver 2005

• haribabu_rk

  Valued Member

  Points: 58

  More actions

  July 9, 2009 at 12:04 am

  #136087

  Hi

  I have an Oracle11g DB on a LINUX(Oracle Enterprise Linux) platform and I need to create a linked server in my SQL Server 2005 DB. The SQL Server is on a 32-bit Windows Server 2003 Standard Edition and I've installed ODAC 11g Beta 11.1.0.7.10 components.

  How to create Linked Server in Sqlserver 2005 for Oracle11g?

  Can any one please tell me the steps to create linked server.

  thanks

  hari

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  July 9, 2009 at 4:11 pm

  #1022756

  This question is not related to SSIS. I would suggest you ask your question here.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/