Oracle Configuration ODBC

Source: Internet
Author: User
Tags odbc connection

Excerpt from: http://www.cnblogs.com/shelvenn/p/3799849.html

I am using Windows 10, 64-bit operating system.

1. Download the driver package

Base pack: Instantclient-basic-windows.x64-11.2.0.3.0.zip

ODBC Package: Instantclient-odbc-windows.x64-11.2.0.3.0.zip

I downloaded 11.2.0.3 version, two package version must be consistent. Http://www.oracle.com/technetwork/topics/winx64soft-089540.html

2. Unzip the installation

Unzip the above two packages, put the extracted files in the same directory (merge), note that 2 packets after the decompression of all the files must be placed in a directory, assuming that the d:\\instantclient_11_2

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

After the installation is successful, run the 64-bit ODBC driver configuration program "C:\windows\SysWOW64\odbcad32.exe"

Note: The Odbcad32.exe directory for the 64-bit system should be in SysWOW64.

No accident, the ODBC driver has been installed successfully, open ODBC data Source Administrator can see the ODBC driver entry:

  

3. Select the ODBC configuration DSN, for example, can be based on the actual situation of the world Oracle ODBC Driver configuration.

  

Click Test Connection to enter a password for connection testing verification

After the test connection is successful, you can use ODBC to connect to the database, Enjoy it!

In addition, I use ADO to block ODBC connections. The ODBC connection string test is successful and can be used: PROVIDER=MSDASQL.1; Persist Security Info=false; User ID=AVLS; Password=1;data SOURCE=ORCL;

and send an Oracle ODBC connection string Rollup: http://www.connectionstrings.com/oracle/So many people contribute really good!

Again: Configuring an Oracle ODBC driver requires the configuration environment variable, which allows the driver to find the Tnsnames.ora below D:\instantclient_11_2\NETWORK\ADMIN The Tnsnames.ora file contains a connection string to the Oracle server;

You only need to configure the value of the ORACLE_HOME environment variable to D:\instantclient_11_2. It has been tested, hehe. Thank you, no compliments, very useful.

With regard to environment variables, there is also an ODBC-driven language setting that needs to be configured, Nls_lang:simplified Chinese_china. ZHS16GBK current test can solve the problem of SQL query Chinese garbled by ODBC.

Reference connection: http://bbs.51cto.com/thread-1037322-1.html

Oracle Configuration ODBC

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.