Web server configuration of ADO. Net EF + Oracle

1. Install the simplified dotnet35sp1 version

2. Register eforacleprovider:

C: \> gacutil/I eforacleprovider. dll

Gacutil.exe and eforacleprovider. dll are available in the current directory. Eforaclesampleprovider ProjectSource codeObtained after compilation

Eforacleprovider. dll. If the server has a vs2008 environment, you can directly compile it to achieve the registration effect.

3. Configuration: C: \ WINDOWS \ Microsoft. NET \ framework \ v2.0.50727 \ config \ machine. config

<Add name = "Ef ORACLE data provider" invariant = "eforacleprovider" Description = "Ef provider for Oracle"

Type = "eforacleprovider. eforacleproviderfactory, eforacleprovider, version = 1.0.0.0, culture = neutral,

Publickeytoken = def642f226e0e59b "/>

Between <dbproviderfactories> </dbproviderfactories>

4. Simplified Oracle client Configuration:

Add the system environment variable tns_admin. The value is c: \ instantclient.

Add: C: \ instantclient to the path value of the environment variable.

Required file:

Msvcr71.dll
OCI. dll
Oraociei11.dll

You do not need to install oracleclient or odtwithodac. The dllcan be downloaded from odac111_21xcopy.zipor instantclient-basic-win32-11.1.0.7.0.zip.

.

5. Configure tnsnames. ora and put it in the instantclient directory.

RCM =
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = 192.168.1.200) (Port = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = RCM)
)
)

6. It takes effect after restart.

In Windows XP SP3 environment, the test passes.