Solved

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

Posted on 2014-12-23
4
864 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
[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
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 82

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 77

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

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

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

Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

622 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