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

Hi All,

This is a very common error which comes when your system doesn't hold enough permissions.

If you are trying to connect with oracle database then sometimes you get
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

1. Try to add Everyone / Read for Oracle home and all sub folders and restart IIS - this should solve problem.

Note - While you give permissions for Oracle_home folder ensure the sub folders are inherited with the permissions. For this -> right click your folder -> Security -> Advanced->Change Permissions
and check "Replace all child object permissions with inheritable permissions from this object".

Then Restart your system. Now Run your project it will work.

2.In your project if you encounter "OCIEnvCreate failed with return code -1 but error message text was not available with ODP.net" then

Run -> C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe  -i 

 The version v2.0.50727 in the above code may vary according to the framework installed.

3. While Running the above code if you encounter 
 An error has occurred: 0x8007b799
You must have administrative rights on this machine in order to run this tool.

 Then you should Turn off the UAC to fix this.
For this go to
Start > Control Panel > System and Security > Action Center > Choose Your UAC Level - Set this to Never Notify (Requires a restart); 

You are done!