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

rmartes
rmartes used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
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 TarasovHead of system administration department

Commented:
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.
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
>>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.
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
Should I install the latest ODAC or the one for the my specific Oracle db?
Victor TarasovHead of system administration department

Commented:
You must install ODP.NET for Your Oracle client.
Lates version ODP.NET use Oracle client 11.2
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
Newer versions will connect to older database.

You really don't need ODAC.  You just need ODP.Net installed with whatever version of the Oracle Client you already have installed.

If you don't have an Oracle Client installed, that is the reason for your error.  The MSoft drivers sit on top of Oracle's.

You just need to make sure you install the same version of ODP.Net on the final machine as you have for development.

There is a detailed discussion of that here:
http://www.experts-exchange.com/Database/Oracle/Q_27020817.html

Author

Commented:
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?
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
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.

Author

Commented:
Thank You!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial