WINDOWS10 Oracle ODBC installation configuration

Project is urgent, need to deliver results in a short time, new team members, the database design is too low, it is difficult to understand the relationship between the database table structure, in order to enable new colleagues to better understand the database table structure, deliberately using PowerDesigner to Oracle, MySQL database reverse generation of physical diagrams, Concept map, hope to bring new colleagues to help, better improve the development efficiency

I. Oracle ODBC Data Source Configuration

1. Download the driver package

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

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

: http://www.oracle.com/technetwork/topics/winx64soft-089540.html

Baidu Network disk: Http://pan.baidu.com/s/1i5o9zFn

2. Decompression and 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 C:\job\instantclient_12_1

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

3. Configuring the ODBC Driver

Set up-about--management tools,

Click "Add"

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

Note: Not successful, it is probably the wrong version

WINDOWS10 Oracle ODBC installation configuration