Oracle Linux Odbc: Difference between revisions

From Objectif Client Inc
Jump to navigation Jump to search
 
Line 30: Line 30:


== Odbc Configuration Sample ==
== Odbc Configuration Sample ==
<pre>
[OracleODBC-10g]
[OracleODBC-10g]
Description = Oracle ODBC driver for Oracle 10g
Description = Oracle ODBC driver for Oracle 10g
Line 35: Line 36:
FileUsage = 1
FileUsage = 1
Driver Logging = 7
Driver Logging = 7
</pre>

Latest revision as of 20:09, 19 June 2015

Odbc Installation

Download driver | instant Client Downloads for linux

Download Instant Client Package - Basic and Instant Client Package - ODBC

unzip both zip file

cd /opt/oracle/instantclient_12_1
ln -s libclntsh.so.12.1 libclntsh.so
ln -s libocci.so.12.1 libocci.so

Validate missing library

ldd /opt/oracle/instantclient_12_1/libsqora.so.12.1

Add link for missing library

cd /usr/lib/x86_64-linux-gnu
ln -s libodbcinst.so.1.0.0 libodbcinst.so.2

export LD_LIBRARY_PATH and PATH <pr> export LD_LIBRARY_PATH=/opt/oracle/instantclient_12_1:$LD_LIBRARY_PATH export PATH=/opt/oracle/instantclient_12_1:$PATH

Odbc Configuration Sample

[OracleODBC-10g]
Description = Oracle ODBC driver for Oracle 10g
Driver = /usr/lib/oracle/10.2.0.3/client/lib/libsqora.so.10.1
FileUsage = 1
Driver Logging = 7