VB.Net - Oracle Client Deployment

Posted on 2006-05-26
Last Modified: 2008-02-01

We have developed a client/server application in and used oracle as the database. My question is what do we have to install on the client machine in order to work ?
I know for sure that we have to install .net framework 1.1 .

What Oracle Client do we have to install ( can you provide me with a link on what do I have to download)  ? Is there a way to connect to oracle server by just installing an oracle client and without changing the tnsnames to point to the server (connect directly from the application )?

Question by:Cosine_Consultants
    1 Comment
    LVL 2

    Accepted Solution

    For sure you need MS .NET 1.1 (or better to use .NET 2.0).
    However, if you want to have an Oracle connectivity, you have two main options:

    Use the built-in OracleClient data provider supported by .NET framework, but you need also Oracle Client to be installed in the machine and the Oracle DB on the server should be of version 8i or higher.
    To use the Oracle Managed Provider, you need to add a reference to the assembly System.Data.OracleClient.dll for your project. Seek the MSDN for how to use the OracleClient namespace

    You could use the Oracle Developer Tools for Visual Studio .NET, you could download the tool from
    and there also you will find many tutorials on how to use it

    in both cases you don't need to change the tnsnames

    good luck

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
    A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    759 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

    10 Experts available now in Live!

    Get 1:1 Help Now