• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • Last Modified:

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

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 asp.net 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).
1 Solution
Carl TawnSystems and Integration DeveloperCommented:
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now