Where should i install the Oracle Data Provider for .NET (ODP.NET)

Posted on 2006-04-23
Last Modified: 2012-06-27
Hi experts,

As you now to connect to oracle database with .net there are drivers has to be installed and couple of thing to do, however my question is where should i install the Oracle Data Provider for .NET (ODP.NET), should i install it on the SSRS Server or Database Oracle Server.

one thing else about connecting with or VB forms its ok with me but I'm trying to deploy reports by connecting to oracle using SSRS (Sql reporting services. 2003)

when i deploy the reports on the servers above it says the Clint or driver is not installed and when i use my local database it works because my OS is win adv2000  i have on it .net framework 1.1,sql database oracle database,VS.NET 2003 and SSRS 2003 and also have installed the Oracle Data Provider for .NET (ODP.NET).
Question by:bduhaish
    1 Comment
    LVL 52

    Accepted Solution

    The client tools need to be installed on any machine that needs to connect to the Oracle DB. So in your case you need to install them on the SSRS box.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    In .NET 2.0, Microsoft introduced the Web Site.  This was the default way to create a web Project in Visual Studio 2005.  In Visual Studio 2008, the Web Application has been restored as the default web Project in Visual Studio/.NET 3.x The Web Si…
    Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    729 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