Unable to load DLL (oci.dll)

[Neo]

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

Can anyone help me out?

Thanks.

 

[Miha Markic [MVP C#]]

asp.net?

 

[M. Zeeshan Mustafa]

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

 

[Neo]

Yes.

asp.net?

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

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

Can anyone help me out?

Thanks.

 

[Neo]

Yes, you are right. Thanks.

Neo

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

 

[Miha Markic [MVP C#]]

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.

 

[DotNetJunkies User]

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.

 

[DotNetJunkies User]

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.

 

[SqlJunkies User]

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.