Post reply

Linked Server..Not sure Where to create..on SQL or on ORACLE

  • November 5, 2008 at 9:34 am

    #127554

    Here is the senerio,

    I need a Linked Server setup between a 2000 SQL Server database and an Oracle 10g database. The SQL database will execute a stored procedures on the Oracle side, returning results.

    Can any of you give any advice on this..Here are my questions

    1.On which side do I need to create a linked server...on SQL or on ORACLE based on scnario given above.

    2.Any details on how to setup linked server based on scnario.

    Thanks in Advance.

  • November 5, 2008 at 10:13 am

    #894396

    Hi,

    You set up the Linked Server on SQL Server. It is usually quite easy, but with Oracle there are some extra considerations and software you need to install.

    Use this article to set up the linked server "How to set up and troubleshoot a linked server to an Oracle database in SQL Server", http://support.microsoft.com/kb/280106.

    It includes a Step-by-Step and then also lists a number of common issues.

    HTH!

    /Elisabeth

    elisabeth@sqlserverland.com
    MCITP | MCT
    http://sqlblog.com/blogs/elisabeth_redei/
    http://linkedin.com/in/elisabethredei

  • November 5, 2008 at 1:46 pm

    #894513

    Thanks for your reply. This article is really very helpful.

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

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