Windows Oracle ODBC Installation configuration

Environment: Windows 7, 32-bit operating system

1. Download the driver package

The Oracle website is available for download.
Base pack: Instantclient-basic-win32-10.2.0.4.zip
ODBC Package: Instantclient-odbc-win32-10.2.0.4.zip

Two packages must be in the same version.

2. Unzip the installation

Unzip the above two packages, put the extracted files in the same directory (merge), note that all the files after the 2 package decompression must be placed in a directory, such as D:\\instantclient_10_2
For example, you first extract the base package to the D packing directory, there will be D:\\instantclient_10_2 folder, and then extract the ODBC package to a place, all copied to the folder.

Open cmd with administrator privileges, enter the directory, run Odbc_install.exe to install.

After the installation is successful, run the 32-bit ODBC driver configuration program "C:\windows\System32\odbcad32.exe". (or directly click Data Sources (ODBC), management tools, Control Panel)

If the ODBC driver installation succeeds, open ODBC data Source Administrator to see that there are already ODBC driver entries:

3. Configure DSN

As below, the above section of the PBDB2015 is configured before it is available. How exactly is it configured?
First click on the User DSN, then click Add, select Oracle in Instantclient10_2, the popup dialog is as shown in the figure below.
The data source name is a custom. The main TNS Service Name should be written in full, such as 127.0.0.1:1521/pdbd2015. Local, 1521 port, DB instance name pdbd2015. Do not write only a local address or database instance name, which will report ORA-12154 errors .

The user ID is the username. Click on test Connection and enter the password to see the test connection is successful.

Reference: Http://www.cnblogs.com/shelvenn/p/3799849.html This is the operating system 64 bits. The 64-bit students can take part.
Configuration of 64-bit Windows 7 under 32-bit Oracle (including XE) ODBC data sources
http://bbs.51cto.com/thread-1037322-1.html just make reference.

Windows Oracle ODBC Installation configuration