Linux ODBC: Oracle Instant Client

Note that the bundled SQDR Oracle 8 driver is recommended in most situations, but the Oracle Instant Client can be also be used.

If this is a combined tier scenario (i.e. you have installed SQDR Plus and SQDR on the same system), then Oracle Instant client is present in the SQDR Plus installation.

add this stanza to /etc/odbcinst.ini

[OracleIC]
Driver=/opt/stelo/sqdrplus/OracleIC/libsqora.so.19.1
Setup=
FileUsage=
CPTimeout=
CPReuse=

a typical DSN looks like

[SRV01]
Driver=OracleIC
ServerName = SRV01

where SRV01 is an entry in tnsnames.ora.

Set the environment variable TNS_ADMIN to the directory containing tnsnames.ora.

It may be necessary to add the directory containing the OracleIC binaries to LD_LIBRARY_PATH.