Do not install Oracle How to connect a database (ODBC driver)

Preface:

Recently, using R to develop a data analysis system, you need to connect to the Oracle database to obtain data, but do not want to get a few data to install an oracle, so you want to directly find an Oracle ODBC driver, eliminate the hassle of installing the Oracle client. The following is a record of the installation process, we hope to be helpful.

Text: Download:

First, we need to download two drivers:
instantclient-odbc-win32-11.2.0.1.0 and instantclient-basiclite-win32-11.2.0.1.0.
Address: http://www.oracle.com/technetwork/cn/topics/winsoft-095945-zhs.html

Because the download of Oracle products generally need to register first, so I put the network directly on the disk, if it is too registered trouble friends can download from here: ODBC driver, extract password: j9yr
(If the Baidu cloud disk failure, there are micro-disk: ODBC driver), extract password: P0GG

Installation: Step One: Unzip

First extract basiclite, and then the ODBC inside the files extracted to basiclite that path (do not make the wrong order!). ）。 Such as:

Step Two:

Copy the network folder located on the Oracle database to the Instantclient_11_2 directory you just extracted. (can also be taken from any computer equipped with Oracle)

The computer next to me is equipped with Oracle, and its network folder is G:\app\John\product\11.2.0\dbhome_1

Step Three:

To modify a Network\admin\tnsnames.ora file: Add the following lines of code at the end of the document

ORCL81 =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = 100.100.100.100)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = orcl)    )  )

Note: Change the 100.100.100.100 to the IP where you want to connect the database, and ORCL81 and ORCL can be changed. Special attention do not miss the parentheses or more space or something, this code is very strict, it is possible because a space and the connection is not successful. This code in Tnsnames.ora General also have, can copy paste directly, then modify IP.

Step Four:

Add the environment variable tns_admin, and the path to the ADMIN directory. Such as:

Step Five:

Running the odbc_install.exe in the Instantclient_11_2 directory, a DOS window will appear flashing past.

Step Six:

Go ahead and configure the data source!

Open ODBC Data Source Administrator, System DNS, add, pop up the Create New Data Source window, select Oracle in Instantclient_11_2 to start the new data source!

Reprint please indicate the source, thank you! (Original link: http://blog.csdn.net/bone_ace/article/details/47628725)

Do not install Oracle How to connect a database (ODBC driver)