Oracle 9.2.0 Error: System.Data.OracleClient requires Oracle client software version 8.1.7

(0 votes, average 0 out of 5)

Problem

When using a version of Oracle 9.2.0 in ASP.NET, attempting to access a site which uses System.Data.OracleClient may give an error with the following exception:

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

This is a common error when using ASP.NET with Oracle -- it is in fact a bug in the default Oracle 9.2.0 installation permissions. To fix the error, follow the following solution steps (taken from cited source):

Log on to Windows as a user with Administrator privileges.
Launch Windows Explorer from the Start Menu and and navigate to theORACLE_HOME folder. This is typically the "Ora92" folder under the"Oracle" folder (i.e. D:\Oracle\Ora92).
Right-click on the ORACLE_HOME folder and choose the "Properties" optionfrom the drop down list. A "Properties" window should appear.
Click on the "Security" tab of the "Properties" window.
Click on "Authenticated Users" item in the "Name" list (on Windows XPthe "Name" list is called "Group or user names").
Uncheck the "Read and Execute" box in the "Permissions" list under the"Allow" column (on Windows XP the "Permissions" list is called"Permissions for Authenticated Users").
Re-check the "Read and Execute" box under the "Allow" column (this isthe box you just unchecked).
Click the "Advanced" button and in the "Permission Entries" list makesure you see the "Authenticated Users" listed there with:
Permission = Read & ExecuteApply To = This folder, subfolders and files
If this is NOT the case, edit that line and make sure the "Apply onto"drop-down box is set to "This folder, subfolders and files". Thisshould already be set properly but it is important that you verify this.
Click the "Ok" button until you close out all of the security propertieswindows. The cursor may present the hour glass for a few seconds as itapplies the permissions you just changed to all subfolders and files.
Reboot your computer to assure that these changes have taken effect.

On many data servers, it will be necessary to reboot. If you are running on a local machine (for instance, using an IIS install), a reboot may not be necessary.

Partner Links:

» How to Set Emacs to Word Wrap on Vertical Split

By default, using C-x 3 in emacs splits the window vertically into two buffers. This is very convenient, but for some reason it disables word wrap (even when word wrap is set in the options). To enable word wrap on a vertical split, add the following to your .emacs file (typically located in your home directory):;; Word wrap on vertical split(setq truncate-partial-width-windows nil)Alternatively you can enter the same command during your current session if you don't want this to be...

» Find and Replace Text in Multiple Files

Sometimes it is useful to be able to replace a certain piece of text in multiple files, even across multiple folders. Opening each file and using find/replace is tedious. Fortunately, there is a much easier way using the sed and grep utilities. For Windows users, please to get these programs on your system. Linux and Mac OS X users will already have these programs pre-installed.Launch a terminal window, and cd to the root directory where all of these files and folders exist. Once in the...

» Fix 'Build Path' Error or Missing File in Eclipse Project

Sometimes the Eclipse IDE will refuse to build a project - citing a missing resource or file or just a generic "build path" error. If the resource is not missing but in the folder where it should be, the build path may just need to be refreshed. If you encounter a build error when trying to run a project, try these steps to resolve it:Make all files in the project read-write. To do so, go to the Eclipse workspace in the file manager (e.g. Windows Explorer, Finder, or Nautilus), right-click on...