Cannot open OracleConnection with Oracle 9.2 in ASP.NET

[Dhananjay]

Hi

I'm using System.Data.OracleClient with VisualStudio.NET 2003 and trying to
connect to Oracle 9.2 database. Oracle client software for 9.2 has been
installed and I can perfectly make a connection in a Windows Forms
application. But on the same machine, I cannot make a connection in an
ASP.NET web application. The Exception is raised when I try to open the
connection as follows:

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

What is happening?

 

[David Browne]

Hi

I'm using System.Data.OracleClient with VisualStudio.NET 2003 and trying
to
connect to Oracle 9.2 database. Oracle client software for 9.2 has been
installed and I can perfectly make a connection in a Windows Forms
application. But on the same machine, I cannot make a connection in an
ASP.NET web application. The Exception is raised when I try to open the
connection as follows:

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

What is happening?

Make sure that the OracleClient bin directory is in the system path.
Reboot.
Make sure that the account running the web applicaion can read from the
OracleClient bin directory.

Check out this article from Bob Beauchemin for background and
troubleshooting tips
http://www.fawcette.com/vsm/2003_01/magazine/features/beauchemin/

David

 

[Dhananjay]

Thanks David,

There was a path problem, changing it solved the problem.

 

[Guest]

I read the link above, but it didn't effect.
Could you tell me how to do this step by step?