How do I connect to a Oracle server via SQL Server

• Mark F-428640

  Hall of Fame

  Points: 3659

  More actions

  January 6, 2011 at 2:34 pm

  #243240

  What are the steps to connect from SQL Server 2008 to Oracle DB and once connected can you query the same as in SQL Server. Please let me know if I need to load any Oracle client software or anything else.

  Thanks

• LutzM

  SSC Guru

  Points: 107049

  More actions

  January 6, 2011 at 2:57 pm

  #1270347

  Maybe this link will help you getting started.

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

• Mark F-428640

  Hall of Fame

  Points: 3659

  More actions

  January 6, 2011 at 9:52 pm

  #1270404

  So the following script is what I have so far to attempt accessing the data:

  EXEC sp_addlinkedserver 'OracleSvr',

  'Oracle 7.3',

  'MSDAORA',

  'ORCLDB'

  GO

  SELECT *

  FROM OPENQUERY(OracleSvr, 'SELECT name, id FROM joe.titles')

  GO

  (The above code taken from here --> http://msdn.microsoft.com/en-us/library/ms188427.aspx)

  Where 'ORCLDB' this is suppose to be the alias pointing to the SQL source how do I set up this alias? Can I use SQL Server to do this or do I need to install some configuration tool for this?

• LutzM

  SSC Guru

  Points: 107049

  More actions

  January 7, 2011 at 12:08 am

  #1270446

  Did you actually follow any of the links I pointed you at? Most of them include a line like "Install Oracle client"...

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]