Once installed, you must create a Data Source Name (DSN) to let your applications talk to the database.
Under the tab, click Add , select your new "Oracle in instantclient..." driver, and enter your database credentials and TNS Service Name. Solved: How to install Oracle Instant CLient Basic + ODBC oracle odbc driver download for windows 7 64 bit
Go to .
Create this variable and point it to the folder where your tnsnames.ora file is located (usually the same folder). Once installed, you must create a Data Source
Add C:\oracle\instantclient_12_2 to your system's PATH variable so Windows can find the .dll files. oracle odbc driver download for windows 7 64 bit