Oracle w/ asp.net - "Unable to load DLL (oci.dll)."

[Richard Roche]

I'm using .net 2003 w/ Oracle 9.2. The server explorer
works, and connections work in Windows Applications but in
my asp.net application things fail on the open w/
"Unable to load DLL (oci.dll)." The exact same connection
string works in my test windows application. (all done on
my development machine)

Any ideas appreciated. Thanks.

 

[David Browne]

I'm using .net 2003 w/ Oracle 9.2. The server explorer
works, and connections work in Windows Applications but in
my asp.net application things fail on the open w/
"Unable to load DLL (oci.dll)." The exact same connection
string works in my test windows application. (all done on
my development machine)

Any ideas appreciated. Thanks.

The account running your web site (probably ASPNET) lacks permissions.
To verify and for a quick fix make this account an administrator (you did
say development machine), or switch your processModel to use a different
account.

For a real fix and production environment you need to discover the minimum
rights the account needs to load the oracle driver. These will be file
access, read and write, and perhaps registry access as well.

David

 

[Hussein Abuthuraya[MSFT]]

Richard,

This is a security issue where you don't have permission on the Oracle Folder. When using an ASP or ASP.NET application, everything has to go through security checks.
You may want to start by adding the IUSR_machinename and IWAM_machinename to the Oracle folder where the Oracle client resides and give them Full control. When
adding the accounts make sure to click on the Advanced button and check both check boxes (I think they are called Add and reset ). Then call resetiis to recycle IIS and try
the Application. If you still have problem download FileMon and RegMon from www.Sysinternals.com and use them to audit the File System and the Registry. What you then
need to do is check the trace and look for "Access Denied" in FileMon or "AccDenied" in RegMon trace.

If you found any access denied then it is easy to go to that resource and check the permissions.

I hope this helps!


Thanks,
Hussein Abuthuraya
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.