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

Hi all,

I have problem accessing oracle database and I have tried the solutions from all
over the web and still got no luck. here is my error:
System.Data.OracleClient requires Oracle client software version 8.1.7 or
greater.


 

I have oracle_home directory in my PATH and I also have ORACLE_HOME defined. I
tried to give permission to oracle_home directory to "read and
execute" and reboot and still not luck. I am using asp .net 2.0 and oracle
10g client. Any suggestion would be greatly appreciated.  Thanks a lot.

 

Cheers!

Restart your server after changing permissions. Also give the permissions to all
the oracle folder just to make sure.

I changed all the necessary permission and rebooted several times. I am still 
getting the same error. I checked other related posts and followed the step by
step instructions exactly. still no dice :(. any further help would be
appreciated .

pheww.. I solved it.  I keep getting the same error after I set my permissions. 
I accidentally found something about windows path on the web. The OS(windows)
only picks the path variable up to some length. My path variable is too long
that the OS is not picking it up. so I remove all the junks from path and move
the oracle home to the very beginning of the path to make sure it is picked up.
now it works. hurray!!!..

now i have to remove all the  permissions to that folders since I gave to almost
everyone in the world since it was not working.:P. I might only keep for
Authenticated users and aspnet


so for anyone, just in case , granting permissions  does not solve the problem,
PLEASE CHECK THE PATH VARIABLE BEING TOO LONG !!!! or DUPLICATE ORACLE_HOMEs


 Thanks for the help .