[unixODBC-support] isql cannot find Oracle driver on Fedora Rawhide (64-bit)

[Nick Gorham]

Angela Johansson wrote:
> Nick Gorham wrote:
>
>   
>>> [oracle at vierstein ~]$ isql -v  OracleODBC-11g
>>> [01000][unixODBC][Driver Manager]Can't open lib
>>> '/usr/local/share/oracle/11g/lib/libsqora.so.11.1' : file not found
>>> [ISQL]ERROR: Could not SQLConnect
>>>       
>> Try a
>>
>> ldd /usr/local/easysoft/oracle/libesoracle.so
>>
>> and
>>
>> ldd /usr/local/share/oracle/11g/lib/libsqora.so.11.1
>>
>> And see what it says. Also check that SELinux isn't preventing the libs
>>     
> >from being loaded.
>   
>> --
>> Nick
>>
>>     
>
> Thanks! What a great command!!! And a VERY quick reply from you. :)
> I get:
> [oracle at vierstein ~]$ ldd /usr/local/easysoft/oracle/libesoracle.so
> 	linux-vdso.so.1 =>  (0x00007fffcc0bb000)
> 	libodbcinst.so.1 => not found
> 	libessupp_r.so => /usr/local/easysoft/lib/libessupp_r.so (0x00007f4fc3d33000)
> 	libeslicshr_r.so => /usr/local/easysoft/lib/libeslicshr_r.so
> (0x00007f4fc3c23000)
> 	libm.so.6 => /lib64/libm.so.6 (0x00007f4fc399f000)
> 	libc.so.6 => /lib64/libc.so.6 (0x00007f4fc3630000)
> 	libesextra_r.so => /usr/local/easysoft/lib/libesextra_r.so (0x00007f4fc352f000)
> 	/lib64/ld-linux-x86-64.so.2 (0x0000003993200000)
> [oracle at vierstein ~]$ ldd /usr/local/share/oracle/11g/lib/libsqora.so.11.1
> 	linux-vdso.so.1 =>  (0x00007fff0e5fe000)
> 	libdl.so.2 => /lib64/libdl.so.2 (0x00007f1a0619c000)
> 	libm.so.6 => /lib64/libm.so.6 (0x00007f1a05f17000)
> 	libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f1a05cfb000)
> 	libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f1a05ae1000)
> 	libclntsh.so.11.1 =>
> /usr/local/share/oracle/11g/lib/libclntsh.so.11.1 (0x00007f1a0366a000)
> 	libodbcinst.so.1 => not found
> 	libc.so.6 => /lib64/libc.so.6 (0x00007f1a032fc000)
> 	/lib64/ld-linux-x86-64.so.2 (0x0000003993200000)
> 	libnnz11.so => /usr/local/share/oracle/11g/lib/libnnz11.so (0x00007f1a02e9e000)
> 	libaio.so.1 => /lib64/libaio.so.1 (0x00007f1a02c9d000)
>
> That explains it! My unixODBC rpm package is missing a crucial
> library. So, next stop: Bugzilla.
>
> /Angela
>   

Ok, as you have the Easysoft driver there, the install includes its own 
build of libodbc and libodbcinst Try setting your lib search path to 
include /usr/local/easysoft/unixODBC/lib

-- 
Nick