Windows Oracle ODBC Installation configuration

Source: Internet
Author: User
Tags dsn win32

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.