Avatar of rmartes
rmartes
 asked on

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

Hi Experts,

I'm trying to connect to an Oracle database via my ASP.NET application but I'm getting this error:

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

The server has:
- win server 2003
- IIS 6.0
- asp.net 2.0
- Oracle 10g Client

I found some solutions stating ORACLE_HOME (c:\oracle) folder security issues so I already added the following users, gave them Read & execute, & rebooted.

- IUSR
- ASP.NET
- IWAM
- Authenticated Users

I also imported System.Data.OracleClient into my bin folder within the application.

Don't what else to try.

Please help.

Thanks in advance.
Oracle DatabaseASP.NET

Avatar of undefined
Last Comment
rmartes

8/22/2022 - Mon
slightwv (䄆 Netminder)

What data provider are you tryin to use?

When you installed the Oracle Client, did you install that provider?

When using Oracle and ASP.Net I would suggest you use Oracle's provider, ODP.Net.

Microsoft is desupporting Oracle providers.
Victor Tarasov

Microsoft is desupporting Oracle providers.
but in Framework 2.0 is supported.

To work with Oracle Database from .NET, you can use System.Data.OracleClient from Microsoft. Or use ODP.NET tools from Oracle.
slightwv (䄆 Netminder)

>>but in Framework 2.0 is supported.

I understand that but why bother trying to get it working now when you will eventually have to use ODP.Net anyway.

If the asker would migrate to ODP.Net now, it would make the answer to their question a lot easier since you do not have to mix and match data providers between MSoft and Oracle.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
rmartes

ASKER
Should I install the latest ODAC or the one for the my specific Oracle db?
Victor Tarasov

You must install ODP.NET for Your Oracle client.
Lates version ODP.NET use Oracle client 11.2
ASKER CERTIFIED SOLUTION
slightwv (䄆 Netminder)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
rmartes

ASKER
I already have Oracle 10g Client installed. Is there a way I can install the standalone ODP.Net driver. The Oracle site provides the installs for ODAC 10g. I don't see a download for ODP.Net standalone. Can you provide a link?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
slightwv (䄆 Netminder)

ODP.Net is part of the client.  It is not a stand-alone product.

Just rerun the 10g installer you used to install the client you have.  ODP.Net is an option.
rmartes

ASKER
Thank You!