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

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

Date: Mon, 18 Oct 2004 11:57:06 -0700

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.

Relevant Pages

  • Re: 2G limitation
    ... and has been installed 32-bit Versions of Windows Server 2003 standard ... Oracle can only recognize 2G memory when I have ... You may not be able to use all the available memory on the box.http://support.microsoft.com/kb/291988 ... Windows Server 2003, Standard Edition only in a production environment ...
    (comp.databases.oracle.server)
  • Re: Shutdown abort: could not shutdown the database....
    ... I am using Oracle 10.1.0.4 on Windows Server 2003. ... time-out in LISTEN while waiting for a message ... I wanted to restart the database. ... I rebooted Windows Server and everything started working. ...
    (comp.databases.oracle.server)
  • Re: Id rather wait a year for a superior product!
    ... > to Oracle Rdb and thus even for Oracle Classic it was missing heavy ... There are four reasons for the shift: Linux has hit technological ... Windows Server; and it enjoys the support of Oracle and IBM. ... cost of ownership because of the high cost of Linux administrators; ...
    (comp.os.vms)
  • Re: Oracle 10.2G windows service started but instance is in nomunt mode
    ... Windows Server 2003 Version V5.2 Service Pack 1 ... Starting ORACLE instance (normal) ... what users are in the Administrators ... If the database was created with Oracle's DBCA, you may be able to use ...
    (comp.databases.oracle.server)
  • Re: Oracle 10.2G windows service started but instance is in nomunt mode
    ... Windows Server 2003 Version V5.2 Service Pack 1 ... Starting ORACLE instance (normal) ... Administrative Tools Control Panel, System Tools, Local Users and ... what users are in the Administrators ...
    (comp.databases.oracle.server)