?
Solved

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

Posted on 2009-04-07
4
Medium Priority
?
5,496 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many‚Ķ
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses

765 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