Using Oracle with ITX 10 via ODBC on Linux
In this practical workshop demonstration, I show how to obtain and apply the Oracle Instant Client Basic and ODBC add-on on the Linux platform, then configure the unixODBC installation provided with ITX 10 to be able to use it.
https://www.oracle.com/uk/database/te...
Edits are required to the odbc.ini and odbcinst.ini files (details below) found in the unixODBC/etc folder of your ITX 10 installation.
Oracle adapter connection string:
-DBTYPE oracle -CONNECT orac -USER scott -PASSWORD tiger -T
Example files with bare minimum configuration are shown below.
odbc.ini
[ORAC]
Driver = Oracle 12c ODBC driver
ServerName = orac
odbcinst.ini
[ODBC]
Trace=yes
TraceFile=/opt/ibm/itx10000/logs/odbc.log
[Oracle 12c ODBC driver]
Description = Oracle ODBC driver for Oracle 12c
Driver = /opt/oracle/instantclient_12_2/libsqora.so.12.1
Setup =
FileUsage =
CPTimeout =
CPReuse =