[R-sig-DB] call to isql : can't find libsqora.so.11.1

[Luis Ridao]

R-sig-help,

After succesfully installing the RODBC package and unixodbc/unixodbc-dev on
Ubuntu 12.04 LTS (64 bit) (thanks again to Dirk and others) i came across
the following error when invoking isql:

$ isql -v myDatabase myUID myPWD

[01000][unixODBC][Driver Manager]Can't open lib
'/u01/app/luisr/product/11.1.0/client_1/lib/libsqora.so.11.1' : file not
found
[ISQL]ERROR: Could not SQLConnect

Tried to check if some library is missing:

luisr using luisr:~$ ldd
/u01/app/luisr/product/11.1.0/client_1/lib/libsqora.so.11.1
    linux-gate.so.1 =>  (0xf77d9000)
    libdl.so.2 => /lib/i386-linux-gnu/libdl.so.2 (0xf7726000)
    libm.so.6 => /lib/i386-linux-gnu/libm.so.6 (0xf76fa000)
    libpthread.so.0 => /lib/i386-linux-gnu/libpthread.so.0 (0xf76de000)
    libnsl.so.1 => /lib/i386-linux-gnu/libnsl.so.1 (0xf76c4000)
    libclntsh.so.11.1 =>
/u01/app/luisr/product/11.1.0/client_1/lib/libclntsh.so.11.1 (0xf5b78000)
    libodbcinst.so.1 => /usr/lib/i386-linux-gnu/libodbcinst.so.1
(0xf5b65000)
    libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xf59bb000)
    /lib/ld-linux.so.2 (0xf77da000)
    libnnz11.so => /u01/app/luisr/product/11.1.0/client_1/lib/libnnz11.so
(0xf5810000)
    libaio.so.1 => /lib/i386-linux-gnu/libaio.so.1 (0xf580d000)
    libltdl.so.7 => /usr/lib/i386-linux-gnu/libltdl.so.7 (0xf5803000)

it seems ok (actually it's exactly the same output as in my older
laptop:Ubuntu 12.04 LTS 32-bit)

Comparing with an old 32 bit version in Ubuntu 12.04 LTS i can only see
this difference:

### OLD 32bit Ubuntu 12.04(32bit)
dpkg --list | grep unixodbc
hi  unixodbc
2.2.14p2-5ubuntu4                      i386         Basic ODBC tools

### NEW 64bit laptop Ubuntu 12.04(64bit)
dpkg --list | grep unixodbc
ii  unixodbc
2.2.14p2-5ubuntu3                   Basic ODBC tools
ii  unixodbc-dev
2.2.14p2-5ubuntu3                   ODBC libraries for UNIX (development
files)

is this the problem? a conflict between 32 and 64 bit?
and if so, how can i sort it out?

thanks in advance

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
Luis Ridao Cruz
Faroe Marine Research Institute
N�at�n 1, P.O. Box 3051
FO-110 T�rshavn
Faroe Islands
Tel   : (+298) 353900
Fax: : (+298) 353901
e-mail: luisr using hav.fo
           luridao using gmail.com
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-

	[[alternative HTML version deleted]]