How to connect to Oracle DB via ODBC
Solution 1:
As the original poster said...
For future users: Instructions on how to install instant client and sqlplus correctly.
- Download and unzip in same folder instant client ODBC package.
- Execute
odbc_install.exe.- Configure ODBC connection in Windows.
- Done.
Solution 2:
Rdb was a database system created by DEC (Digital) running on OpenVMS that Oracle acquired in 1994. So "ODBC Driver for RDB" is not right driver.
The solution is to get the Oracle ODBC driver.
Also note that some applications require the ODBC datasource to be as a system DSN while others prefer a user DSN.