Connect oracle10g Installation-free client Solutions __oracle

Connecting oracle10g Installation-free client Solutions

First, search for the following files on the machine where the ORACLE server is installed,
Oci.dll
Ocijdbc10.dll
Ociw32.dll
Orannzsbb10.dll
Oraocci10.dll
Oraociei10.dll
Sqlnet.ora
Tnsnames.ora
Classes12.jar
Ojdbc14.jar

Made into a compressed file, configured to use the target computer.
1.

2. Configure the D:/oracleinstantclient Tnsnames.ora file to modify only the server address, service name, and port.

3. Configure environment variables and add d:/oracleinstantclient to the PATH variable

4. Add the following key value to the registry

[Hkey_local_machine/system/currentcontrolset/control/session Manager/environment]

"Ld_library_path" = "d:/oracleinstantclient"

"Nls_lang" = "American_america." ZHS16GBK "

"Tns_admin" = "d:/oracleinstantclient"

5. If it is a asp.net application, assign the D:/oracleinstantclient folder read and Write permissions to the ASPNET user.

With the above settings, you can implement the install-free Oracle client and connect to the Oracle database server.

Can also be the above uncompressed file and manual process into the installation package, to achieve automatic installation.

Attention:

1, use the above method, connect oracle9.2, should also have no problem.

2, if use JDBC Connection, need to download Instantclient-jdbc-win32-10.1.0.2.zip: The package containing the JDBC driver will oracleinstantclient.rar uncompressed to a directory, such as d:/ Oracleinstantclient