Windows Oracle ODBC installation and configuration

Source: Internet
Author: User

Windows Oracle ODBC installation and configuration

Environment: Windows 7, 32-bit OS

1. Download the driver package

The official Oracle website can be downloaded.
Base package: instantclient-basic-win32-10.2.0.4.zip
Odbc package: instantclient-odbc-win32-10.2.0.4.zip

The versions of the two packages must be consistent.

2. Unzip and install

Extract the preceding two packages and put the extracted files in the same directory (merged). Note that all the files extracted from the two packages must be placed in one directory, for example, D: \ instantclient_10_2.
For example, if you first extract the base package to the root directory of drive D, the folder D: \ instantclient_10_2 will be displayed. Then, extract the odbc package to a place and copy it all to the folder.

Use the administrator privilege to open the directory, enter the directory, and run odbc_install.exe for installation.

After the installation is successful, run the 32-bit ODBC driver configuration program "C: \ windows \ System32 \ odbcad32.exe ". (Alternatively, choose Control Panel> Administrative Tools> data source (ODBC ))

If the ODBC driver is successfully installed, open the ODBC data source Manager and you will be able to see the ODBC driver items:

3. Configure DSN

As shown below, the above section of pbdb2015 is only available after configuration. How to configure it?
First, click User DSN, then click Add, and select Oracle in instantclient10_2. the pop-up dialog box is shown in the figure below.
Data Source Name is the Data Source Name, which is customized. The main TNS Service Name should be complete, such as 127.0.0.1: 1521/pdbd2015. Local, port 1521, database instance name pdbd2015. Do not write only a local address or database instance name, it will report a ORA-12154 error.

 

The User ID is the User name. Click Test Connection and enter the password. The Test Connection is successful.

Related Article

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.