Unable to load DLL (oci.dll)

  • Thread starter Thread starter Neo
  • Start date Start date
N

Neo

I installed oracle client 9.2.0.1 on winxp.But when I open a connection to
oracle server, there is an exception:DllNotFoundException: Unable to load
DLL (oci.dll). I found oci.dll in "D:\oracle\ora92\bin".

Can anyone help me out?

Thanks.
 
You may not have proper permissions set at oracle
folder that contains oci.dll.

Give asp.net worker process user (usually ASPNET) these
permissions on "D:\oracle" folder (apply recursively)

- Read
- Read & Execute
- List Folder Contents
 
Yes.

Miha Markic said:
asp.net?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Neo said:
I installed oracle client 9.2.0.1 on winxp.But when I open a connection to
oracle server, there is an exception:DllNotFoundException: Unable to load
DLL (oci.dll). I found oci.dll in "D:\oracle\ora92\bin".

Can anyone help me out?

Thanks.
Click to expand...
Click to expand...
 
Yes, you are right. Thanks.

Neo

M. Zeeshan Mustafa said:
You may not have proper permissions set at oracle
folder that contains oci.dll.

Give asp.net worker process user (usually ASPNET) these
permissions on "D:\oracle" folder (apply recursively)

- Read
- Read & Execute
- List Folder Contents
Click to expand...
 
And/Or change the account under which asp.net application runs, by adding
the following line into web.config under system.web node:
<identity impersonate="True" userName="<name>" password="<password>" />
where <name> and <password> are windows account name and password.
 
May I ask why that would make any difference? I thought by having impersonate=true without specifing name/pwd, it's using the account specifiied in the IIS Authentication Control area instead. I really don't want to leave pwd in plaintext in the web.config file.
 
May I ask why that would make any difference? I thought by having impersonate=true without specifing name/pwd, it's using the account specifiied in the IIS Authentication Control area instead. I really don't want to leave pwd in plaintext in the web.config file.
 
Is there any thing else that would cause this error? I am getting it even after giving the ASPNET user the permissions to the bin folder. This is for a web application being deployed on a Windows 2000 Advanced Server, using Oracle 9.2.
 
Back
Top