System.Data.OracleClient requires Oracle client software version 8.1.7

by

I’ve run into this error dozens of times:

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 Windows 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.

More Related Contents:

  1. Trying to write the code to fill a field with smaller number
  2. Is there a conditional ternary operator in VB.NET?
  3. Classes vs. Modules in VB.NET
  4. Hidden Features of VB.NET?
  5. AndAlso/OrElse in VBA
  6. Count specific character occurrences in a string
  7. How to create Control Arrays in VB .NET
  8. Add an event to all Forms in a Project
  9. ByRef vs ByVal Clarification
  10. Disable Image blending on a PictureBox
  11. How to print hidden and visible content of a Container with ScrollBars
  12. How to order list of files by file name with number?
  13. The VB.NET ‘With’ Statement – embrace or avoid?
  14. Convert a string to a datetime
  15. VB.NET What is the purpose of a class or module?
  16. no value given for one or more required parameters
  17. Parse a string to an Enum value in VB.NET
  18. A first chance exception
  19. API for Determining if App is Running on Citrix or Terminal Services [closed]
  20. Integer.Parse vs. CInt
  21. VB.NET Checking if a File is Open before proceeding with a Read/Write?
  22. How to read a specific line from a text file in VB
  23. loop over all textboxes in a form, including those inside a groupbox
  24. VB.net Need Text Box to Only Accept Numbers
  25. Automatically adjusting winform and controls to screen size
  26. VB.Net Passing values to another form
  27. VB.NET IntelliSense : Disable newline on ENTER autocomplete
  28. Why use TryCast instead of DirectCast?
  29. how to prevent the Image.FromFile() method to lock the file
  30. When clicking “btnLogin”, my forms decrease in size.

Leave a Comment