RE: Error using Oracle ODP.NET from Web App on Windows 2003

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John Kuhn (JohnKuhn_at_discussions.microsoft.com)
Date: 10/18/04 

Date: Mon, 18 Oct 2004 12:33:02 -0700

Was this under Windows Server 2003?

All files under bin were given read/execute permission for ASPNET - no luck

Did you use the user ASPNET?

"owyn" wrote:

> When I got that error I found that my installation of the Oracle files had
> not given me the permissions on the DLLs on the computer. I just gave my self
> and the machine permissions on all the files in the Oracle folder and it
> started to work.
>
> "John Kuhn" wrote:
>
> > What additional steps are needed to allow web apps to access oracle ODP.NET
> > resources under Windows Server 2003?
> >
> > When using Oracle's ODP.NET (9.2.0.401) from a WebForm I get permission
> > errors when invoking oracle - System Error: Unable to load DLL (OraOps9.dll).
> >
> > Impersonation fixes the error - but cannot be used as a production solution.
> >
> > Under Windows 2000 all you needed to do after installing the Oracle ODP was
> > granting read and execute permissions to OraOps9.dll for ASPNET. This was
> > done on 2003 with no effect.
> >
> >
> >