Solved

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

Posted on 2014-12-23
4
800 Views
Last Modified: 2015-03-18
Hi Experts,

     I get the error "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater" whenever my application tries to connect to Oracle.  Any ideas?  All of the articles that I find online are talking about Oracle not having been installed correctly (permissions on Oracle home directory).  But that just doesn't make any sense to me why I would get such an error on the client side that would be cause by Oracle having been installed incorrectly .  Here's my setup:

Client: WCF webservice (C#), Windows Server 2008,  .NET 4.5 (using native .NET Oracle client, not Oracle Oracle client)
Server: Unix hosting Oracle 11

Thanks in advance!
0
Comment
Question by:axnst2
4 Comments
 
LVL 75

Expert Comment

by:käµfm³d 👽
ID: 40514806
...using native .NET Oracle client
What do you mean by "native"? If you mean that found under System.Data.OracleClient, then you really shouldn't be using that as it has been deprecated. MS had deferred to Oracle's client in terms of their official Oracle support, even though they don't package it with the Framework. You need to find the appropriate version of ODP.NET for your database.
0
 
LVL 78

Assisted Solution

by:David Johnson, CD, MVP
David Johnson, CD, MVP earned 167 total points
ID: 40514807
.net has no native controls for oracle.. they have to be either installed on the client or ADDED to your deployment
http://www.oracle.com/technetwork/topics/dotnet/downloads/index-2235287.html
0
 
LVL 40

Assisted Solution

by:Jacques Bourgeois (James Burger)
Jacques Bourgeois (James Burger) earned 166 total points
ID: 40515428
OracleClient is marked as Obsolete starting in VS2010, which means that it will eventually be abandoned by Microsoft.

It is suggested that you switch to the Oracle Data Provider
0
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 167 total points
ID: 40515797
As everyone else already mentioned but to repeat slightly differently:
MSOFT drivers sit on top of Oracle drivers.  You MUST have an Oracle client.

I would suggest the new Managed Driver.  It doesn't require a client install.

The download link above is a Beta version.  I would not use it.

Here is the production download links:
http://www.oracle.com/technetwork/topics/dotnet/downloads/index.html
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

930 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

9 Experts available now in Live!

Get 1:1 Help Now