Post reply

How do I connect to a Oracle server via SQL Server

  • 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

  • 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]

  • 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?

  • 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]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply