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 Configure iTunes to Import in MP3 Format

iTunes is a widely used media program, but often times users become frustrated that the default encoding for ripping a new CD is Apple's proprietary format. A more widely used format such as MP3 is more convenient. Here is how to configure iTunes to rip in MP3:Open iTunes and navigate to Edit -> Preferences. On Mac this is under iTunes->Preferences.On the General tab, click the "Import Settings" button.In the "Import Using" dropdown, select "MP3 Encoder". Now...

» Troubleshooting CIFS Sign In Issue on LG Blu-ray Players

Most LG Blu-ray players provdie a useful interface for streaming media off of a home network. The interface is sometimes called 'Home Link"; in other players it's simply under Movie or Music. In both cases, shared folders under a network computer may not actually show up, and when the network computer is selected, a "CIFS Sign In" prompt will show up. CIFS is a standard for remotely sharing files, but the sign in prompt is a sympton of another issue which can be fixed....

» PHP Parse Error: Unexpected $

ErrorA PHP parse error returns, citing an "unexpected $". Because this is a parse error, the PHP script does not run to any extent.SolutionThis error almost always results in a missing bracket somewhere. Check your code carefully for missing brackets. Using a PHP IDE can be useful for checking brackets that are not closed. Brackets that span multiple PHP sections can be the trickiest to miss. For instance:12345678910<?php$x = 3;if($x == 3){?> <a...