IIS 7.x and Oracle Client 11.x : System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater


Applies to:

  • IIS v7 on Windows 2008/R2
  • Oracle client v11.x 64-bit

Symptom:

an exception “System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater” may occur when Combination of IIS v7, Oracle client v11.x and usage of “System.Data.OracleClient” is used on an on an ASP.Net application.

Cause:

“Authenticated Users” group must have read and execute access to “Oracle Home”

Solution:

Locate the “Oracle Home” folder on the web server, right click and select “Properties”. Go to “Security” tab, and locate the “Authenticated Users” group on the name list. If it’s not there, add it by clicking on the “edit” button, and proceed to add it with the button “Add” on the “permission” window, and give it the “Read & Execute” permission. Click the “OK” button to close the “Permission” window and back to the “Security” tab. Next, on the “Security” tab, press the “Advanced” button to go to “Advanced Security Setting”, and proceed to press the “Change Permissions..”. Highlight the “Authenticated Users” group from the list, and press “Edit”. On the next screen, make sure “Apply to” has “This folder, subfolders and files” selected, then press OK to save the change and close the Window. Press OK until all properties windows are closed, and reboot the server to make sure all changes are in effect

index
Permission change on Advanced Security Setting
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s