System.Data.OracleClient exception while using multiple Oracle homes

[Michael via DotNetMonster.com]

Hi,

I'am getting "System.Data.OracleClient requires Oracle client software
version 8.1.7 or greater" in ASP.Net apps while trying to open Oracle
connection.
I am using Oracle Data Provider to connect to oracle database and
have two Oracle clients 8.0 and 9i on my local PC.
(I am using Oracle forms and reports that requires 8.0 and ASP.Net which
needs 9i).
I set DEFAULT_HOME to 9i on my PC.
There is an ASPNET account with Administrator privileges.

Thanks,
Michael.

 

[Angel Saenz-Badillos[MS]]

I assume that you rebooted after changing the oracle home (iisreset may work
too but why take chances). The next step I would do would be to fire up a
debugger like the windows debugger and attach it to your project, take a
look at the dlls that you are loading and make sure that they are from the
9i directory.

If after reboot and verifying that you are loading the correct dlls you
still see this problem please let me know.
Thanks,
--
Angel Saenz-Badillos [MS] Managed Providers
This posting is provided "AS IS", with no warranties, and confers no
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.
I am now blogging about ADO.NET: http://weblogs.asp.net/angelsb/

 

[Jim Brandley]

This one is typically a permission issue, though the message doesn't imply
that. Try using filemon (www.sysinternals.com). Scan the output for access
denied. That will point to the problem directory.