Click here to Skip to main content
16,015,827 members
Please Sign up or sign in to vote.
2.33/5 (2 votes)
See more:
Hi,

I am implementing asp.net web applications in windows server 2008 r2 but I am getting this error

Error : system.data.oracleclient requires oracle client software version 8.1.7 or greater

My web applications are running in my development pc with window XP OS.


What should I do to solve this issue?


Thanks in advance.



Hernan Cabrera
Posted
Comments
[no name] 23-Jul-13 10:05am    
Just as a though but did you try installing "oracle client software version 8.1.7 or greater"?

1 solution

Cause

Security permissions were not properly set when the Oracle client was installed on Windows with NTFS. The result of this is that content of the ORACLE_HOME directory is not visible to Authenticated Users on the machine; this causes an error while the System.Data.OracleClient is communicating with the Oracle Connectivity software from ASP.NET using Authenticated User privileges.

Solution

To fix the problem you have to give the Authenticated Users group privilege to the Oracle Home directory.

Log on to Windows as a user with Administrator privileges.
Start Window Explorer and navigate to the ORACLE_HOME folder.
Choose properties on the ORACLE_HOME folder.
Click the “Security” tab of the “Properties” window.
Click on “Authenticated Users” item in the “Name” list.
Un-check the “Read and Execute” box in the “Permissions” list under the “Allow” column.
Re-check the “Read and Execute” box under the “Allow” column.
Click the “Advanced” button and in the “Permission Entries” verify that “Authenticated Users” are listed with permission = “Read & Execute”, and Apply To = “This folder, subfolders and files”. If not, edit that line and make sure that “Apply To” drop-down box is set to “This folder, subfolders and files”. This should already be set properly but it is important that you verify it.
Click the “Ok” button until you close out all of the security properties windows. The cursor may present the hour glass for a few seconds as it applies the permissions you just changed to all subfolders and files.
Reboot, to assure that the changes have taken effect.
Try your application again.

For more info check this : http://stackoverflow.com/questions/447983/system-data-oracleclient-requires-oracle-client-software-version-8-1-7[^]

I hope this will help to you.
 
Share this answer
 
Comments
Hernan K. Cabrera 23-Jul-13 10:59am    
My development pc is 32 bit and the server is 64 bit. Is that an issue with my problem?
Oracle is not yet installed in the windows server 2008 r2.
Sampath Lokuge 23-Jul-13 11:03am    
@Hernan have you tried what above solution gave ? To fix the problem you have to give the Authenticated Users group privilege to the Oracle Home directory on your server machine.
Hernan K. Cabrera 23-Jul-13 11:08am    
Hi Sampath, I will try to install oracle and follow the instruction tomorrow. I will get back to you once i'm done... thanks...
Sampath Lokuge 23-Jul-13 11:12am    
@Hernan No problem.Go ahead :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900