Oracle Database 12.1.0.2
Red Hat Enterprise Linux 6
Hi Team,
I have encountered error below when testing ODBC connection
How to Configure DG4ODBC on 64bit Unix OS (Linux, Solaris, AIX, HP-UX Itanium) to Connect to Non-Oracle Databases Post Install (Doc ID 561033.1)
[root@RHIS-TABLEAU-03 bin]# ./isql demo -v
[01000][unixODBC][Driver Manager]Can't open lib '/usr/local/lib/libmyodbc5a.so' : file not found
[ISQL]ERROR: Could not SQLConnect
content of odbc.ini file
[roshanbi@RHIS-TABLEAU-03 ~]$ cat /etc/odbc.ini
[demo]
Driver = /usr/local/lib/libmyodbc5.so
Description = Connector/ODBC x.x Driver DSN
SERVER = 127.0.0.1
PORT = 3306
USER = demo
PASSWORD = My$$$$
DATABASE = demo
OPTION = 0
TRACE = OFF
The file is present in the directory. Can anyone please suggest.
[roshanbi@RHIS-TABLEAU-03 ~]$ ls -ltr /usr/local/lib/
total 29668
-rwxr-xr-x 1 root root 10754328 Jan 6 08:10 libmyodbc5a.so
-rwxr-xr-x 1 root root 5881656 Jan 6 08:10 libmyodbc5S.so
-rwxr-xr-x 1 root root 10771616 Jan 6 08:10 libmyodbc5w.so
-rwxr-xr-x 1 root root 505363 Jan 6 11:35 libodbcinst.so.2.0.0
lrwxrwxrwx 1 root root 20 Jan 6 11:35 libodbcinst.so.2 -> libodbcinst.so.2.0.0
lrwxrwxrwx 1 root root 20 Jan 6 11:35 libodbcinst.so -> libodbcinst.so.2.0.0
-rwxr-xr-x 1 root root 972 Jan 6 11:35 libodbcinst.la
-rwxr-xr-x 1 root root 1918259 Jan 6 11:35 libodbc.so.2.0.0
lrwxrwxrwx 1 root root 16 Jan 6 11:35 libodbc.so.2 -> libodbc.so.2.0.0
lrwxrwxrwx 1 root root 16 Jan 6 11:35 libodbc.so -> libodbc.so.2.0.0
-rwxr-xr-x 1 root root 948 Jan 6 11:35 libodbc.la
-rwxr-xr-x 1 root root 521334 Jan 6 11:35 libodbccr.so.2.0.0
lrwxrwxrwx 1 root root 18 Jan 6 11:35 libodbccr.so.2 -> libodbccr.so.2.0.0
lrwxrwxrwx 1 root root 18 Jan 6 11:35 libodbccr.so -> libodbccr.so.2.0.0
-rwxr-xr-x 1 root root 986 Jan 6 11:35 libodbccr.la
drwxr-xr-x 2 root root 4096 Jan 6 11:35 pkgconfig
Thanks!
Joe