Oracle - Unable to load DLL (oci.dll)

[Tony Curtis]

I'm using VS.NET 2003 (VB) and I have been getting this message when I
attempt to use OracleClient to make a connection to Oracle.

Oracle - Unable to load DLL (oci.dll)

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.DllNotFoundException: Unable to load DLL
(oci.dll).

I have tried to do the following so far (as per other postings):-

1/ Reinstalled my Oracle Client 9i
2/ Checked that the various Oracle dlls exist.
3/ Run SQLPlus

Some postings have suggested that it could be security for the user. I have
full admin privs for this machine and that's current user id. Am I missing
the point? Is there anything else I should do?

 

[Miha Markic [MVP C#]]

Hi Tony,

I'm using VS.NET 2003 (VB) and I have been getting this message when I
attempt to use OracleClient to make a connection to Oracle.

Oracle - Unable to load DLL (oci.dll)

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.DllNotFoundException: Unable to load DLL
(oci.dll).

I have tried to do the following so far (as per other postings):-

1/ Reinstalled my Oracle Client 9i
2/ Checked that the various Oracle dlls exist.
3/ Run SQLPlus

Some postings have suggested that it could be security for the user. I have
full admin privs for this machine and that's current user id. Am I missing
the point? Is there anything else I should do?

Yes, the most probably issue is security.
I suppose you are running an asp.net application?
If so, the app itself is running under (very limited) asp.net account.
You should allow asp.net local windows account to read the Oracle's bin
folder and subfolders by setting appropriate NTFS security.

 

[Tony Curtis]

Thanks Miha.
..
Yes I am running an asp.net application? I am running Windows XP, and the
asp.net account was running limited privs, which I have now changed so it
has admin access but it still gives the same message.

You said - " should allow asp.net local windows account to read the
Oracle's bin folder and subfolders by setting appropriate NTFS security"....

I know how to do it in NT but not in XP Professional, or should what i have
already done have fixed it?

Many thanks
Tony

If so, the app itself is running under (very limited) asp.net account.

You should allow asp.net local windows account to read the Oracle's bin
folder and subfolders by setting appropriate NTFS security

 

[Tony Curtis]

Thanks Miha,
That did the trick!

Thanks Miha.
.
Yes I am running an asp.net application? I am running Windows XP, and the
asp.net account was running limited privs, which I have now changed so it
has admin access but it still gives the same message.

You said - " should allow asp.net local windows account to read the
Oracle's bin folder and subfolders by setting appropriate NTFS security"....

I know how to do it in NT but not in XP Professional, or should what i have
already done have fixed it?

Many thanks
Tony

If so, the app itself is running under (very limited) asp.net account.

You should allow asp.net local windows account to read the Oracle's bin
folder and subfolders by setting appropriate NTFS security

Hi Tony,

I
have

Yes, the most probably issue is security.
I suppose you are running an asp.net application?
If so, the app itself is running under (very limited) asp.net account.
You should allow asp.net local windows account to read the Oracle's bin
folder and subfolders by setting appropriate NTFS security.

 

[Tony Curtis]

Figured it out, had to make XP to turn off simple sharing.

Did what you said...worked a treat.

Thanks!

Thanks Miha.
.
Yes I am running an asp.net application? I am running Windows XP, and the
asp.net account was running limited privs, which I have now changed so it
has admin access but it still gives the same message.

You said - " should allow asp.net local windows account to read the
Oracle's bin folder and subfolders by setting appropriate NTFS security"....

I know how to do it in NT but not in XP Professional, or should what i have
already done have fixed it?

Many thanks
Tony

If so, the app itself is running under (very limited) asp.net account.

You should allow asp.net local windows account to read the Oracle's bin
folder and subfolders by setting appropriate NTFS security

Hi Tony,

I
have

Yes, the most probably issue is security.
I suppose you are running an asp.net application?
If so, the app itself is running under (very limited) asp.net account.
You should allow asp.net local windows account to read the Oracle's bin
folder and subfolders by setting appropriate NTFS security.

 

[Miha Markic [MVP C#]]

Hi Tony,

Figured it out, had to make XP to turn off simple sharing.

Yes, I though that was the problem

Did what you said...worked a treat.

Greate.
Btw, don't give admin privleges to asp.net app. It should be restricted as
much as it can be.