I have a web site that I developed on Vista using Vb.net9. It makes a connection to Oracle. for the connection I use System.Data.OracleClient. It works fine on my machine, and our test server, but it does not work on the production server. We installed the Oracle Client 11 on the server. The error is System.Data.OracleClient requires Oracle client software version 8.1.7
We've tried, making a console app that opens the connection, connection runs fine, opens, displays a message and all is well there.
Then we make a simple web form, put it in the directory of the program, just a button, opens the connection, try..catch, grabs error, same error.
The console app was running under an Administrator, web site running under iwam. Is it possible that iwam has a different path?
Best Answer
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 theSystem.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.
ORACLE_HOME
folder.ORACLE_HOME
folder.Try your application again.