Need Step-by-Step process of connecting to Oracle DB using SQL Svr 2005 .NET Connection?

Posted on 2011-10-21
Last Modified: 2012-05-12
I need to use SQL Server 2005 to connect to my ORACLE database.

Can someone please tell me a Step-by-Step process of how to setup. I can access Oracle using SSIS and so my assumption is that I should be able to ACCESS my Oracle DB using SQL Server MANAGEMENT STUDIO as well.... correct?

Any help is greatly appreciated.
Question by:MIKE
    LVL 13

    Accepted Solution

    Check this link

    and you canget the connection strings (how to make it) from here
    LVL 6

    Assisted Solution

    Using «SQL Server Management Studio» you need to configure a component named linked server.

    There is a tutorial here:


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Suggested Solutions

    How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now