Solved

System.Data.OracleClient requires Oracle client software version 8.1.7 or greater Error!!

Posted on 2009-04-07
4
5,476 Views
Last Modified: 2013-12-18
I am having following setup:

Com1: This machine has Oracle 10g XE installed and i am developing my application here in .Net 3.5 sp1. The application is to backup data on the machine using oracle database.

Com2: This machine is having .net framework 3.5 sp1 installed and is not having Oracle.

When i run my application from com1, it successfully connects to database and backups the data.

But, on running the application from com2 i get following error : "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater"

I am using the OracleClient class to access Oracle in my application.

I far as i know we do not need to install Oracle client on every machine where we need to run an application accessing oracle server.

Please tell what can be the possible cause of this error.
0
Comment
Question by:prakhardeep
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 48

Expert Comment

by:schwertner
ID: 24084751
Include the oracle_home in the path .
See
http://thedotnet.com/nntp/451661/showpost.aspx
0
 
LVL 1

Author Comment

by:prakhardeep
ID: 24084813
But the computer from which i am running the application is not having Oracle installed.

I have checked using Wireshark by capturing the packets going from com2 to com1. No packets are sent.

Which means that the application is giving error before sending any packet for connection opening.

On checking the error log, i found out that the error was coming from function Open() of OracleConnection class. Which means that the application is not able to recognize this function when running from com2 but is able to do so when running from com1.
0
 
LVL 48

Expert Comment

by:schwertner
ID: 24085813
You have to use either ADO.NET or ODP.NET to connect Oracle.


First  install the .NET Managed Provider for Oracle. This will allowed you to
make a connection to Oracle with a windows Forms test application running
locally on the server.  
After that  install the MDAC 2.8 components.

 
0
 
LVL 1

Accepted Solution

by:
prakhardeep earned 0 total points
ID: 24095089
We can do it with OracleClient also with following setup:

Actually, the OracleClient class of .Net uses library functions of Oracle dll's to connect to remote Oracle Server.

So, to run your client application having OracleClient class we need to have the Oracle Client dll's installed.

This can be done in two ways:

1. Install Oracle Client on the remote machine, this will require you to run the setup on every machine where you need to run your client application
2. Use the Oracle Instant Client dll's with your client application. You can download the Oracle instant client from the Oracle website. It is just a zip file with the required dll files. Then just copy the dll's in the folder of your client exe.

For downloading InstantClient for Windows x32 : http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

691 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