Link to home
Start Free TrialLog in
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.
Avatar of slightwv (䄆 Netminder)
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.
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.
>>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.
Avatar of rmartes

ASKER

Should I install the latest ODAC or the one for the my specific Oracle db?
You must install ODP.NET for Your Oracle client.
Lates version ODP.NET use Oracle client 11.2
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of 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?
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.
Avatar of rmartes

ASKER

Thank You!