Solved

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

Posted on 2009-04-07
4
5,443 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
  • 2
  • 2
4 Comments
 
LVL 47

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 47

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
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.  …
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

760 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

19 Experts available now in Live!

Get 1:1 Help Now