How to connect to Oracle10g Database without installing the Oracle client

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
Make it into a compressed file and configure it for use by the target computer.

1.SetOracleinstantclient.rarDecompress the package to a directory.,For exampleD: \ oracleinstantclient

2.ConfigurationD: \ oracleinstantclientOfTnsnames. oraFile, you only need to modify the server address, service name, and port. 

3, Configure environment variables, inPathAdd to variableD: \ oracleinstantclient

4Add 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"

5If yesASP. NETApplicationASPnetUser allocationD: \ oracleinstantclientFolder ACL.

 With the above settings, you can achieve installation-freeOracleClient, connectOracleDatabase server.

 You can also create an installation package from the decompressed files and manual processes to achieve automatic installation.

 Note:

1, ConnectOracle9.2.

2If you useJDBCConnection. You need to download it from the official website.Instantclient-jdbc-win32-10.1.0.2.zip:IncludeJDBCDriverPackage