Oracle - Unable to load DLL (oci.dll)

  • Thread starter Thread starter Tony Curtis
  • Start date Start date
T

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?
 
Hi Tony,

Tony Curtis said:
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?
Click to expand...

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.
 
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
Click to expand...
 
Thanks Miha,
That did the trick!
Tony Curtis said:
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
Click to expand...


Miha Markic said:
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.
Click to expand...
Click to expand...
 
Figured it out, had to make XP to turn off simple sharing.

Did what you said...worked a treat.

Thanks!
Tony Curtis said:
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
Click to expand...


Miha Markic said:
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.
Click to expand...
Click to expand...
 
Hi Tony,

Tony Curtis said:
Figured it out, had to make XP to turn off simple sharing.
Click to expand...

Yes, I though that was the problem :)
Did what you said...worked a treat.
Click to expand...

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