Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2014-12-23
4
Medium Priority
?
901 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 84

Assisted Solution

by:David Johnson, CD, MVP
David Johnson, CD, MVP earned 668 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 664 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 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 668 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

916 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