asp.net cannot load Oci.dll error

Problem: NET under windows2003 access Oracle9i Prompt "Unable to load Oci.dll" or "unable to find entry point named Ocienvcreate in DLL Oci.dll" fix method

Solution One

Repair method:

1: Locate the Oracle client's installation directory, for example: E:/oracle/ora92, select the directory, delete the "ASP. NET, users user" in "Property-security" and add it, and give "Full Control or modify permissions"; Full Control or Modify permissions ", note: The site's directory permissions to be set to ervryone full access, or Oracle is good, the site will not be able to access. Reboot.
2: The simplest direct method is to enable ASP. NET user simulation, added in the Web.config <system.web></system.web> configuration section: <identity impersonate= "true" username= "user" password= "Password"/>
such as: <identity impersonate= "true" username= "Administrator" password= "123456" ></identity>

Solution II

Research for a long time, what directory permissions ah, the registry Ah, no effect.

Finally helpless under the Oraclient8.dll,orasql9.dll,oci.dll copy to System32 solve the problem.

The code is as follows

[Hkey_local_machine/software/microsoft/msdtc/mtxoci]

"OracleXaLib" = "Oraclient8.dll"
"OracleSqlLib" = "Orasql8.dll"
"OracleOciLib" = "Oci.dll"

For the first method of the XP system, the default is no security option in the property, the Solution: Tool-> folder option-> View, remove the "Use simple Home sharing" option

by other means

Resolving the ASP.net connection Oracle database appears unable to load DLL (Oci.dll)
Cancel in Folder Options-use Simple File sharing (recommended)
The partition format for the Oracle_home path is in NTFS format:
Ora92 Properties-> Security under Oracle installation directory
Permissions are set to anyone who can access or set up the ASPNET user can access the line
Ensure that asp.net users have access to Oci.dll.