[unixODBC-support] unixODBC - oracle connection : working with isql and not with libreofficeBase /R...

Nicolas Paris niparisco at gmail.com
Tue Jun 25 10:44:43 BST 2013


Hello,

It works now.
I use sudo strace -Ff -p 8060 2>&1 | tee strace-rstudio.log and found that
3 libs where missing :
libociei.so
libclntsh.so.11.1
and libnnz11.so

then i ln -s them and it's now a pleasure to use R with this oracle
database (i2b2)

Thanks a lot





Nicolas PARIS


2013/6/25 Nick Gorham <nick at lurcher.org>

>  On 24/06/13 17:57, Nicolas Paris wrote:
>
>  Hello,
>
> I want to connect to my oracle base. I have unixODBC 2.3.1 installed (with
> the links libodbc.so.2 and  libodbcinst.so.2)
> It works with isql , (querys, etc...):
> +---------------------------------------+
> | Connected!                            |
> |                                       |
> | sql-statement                         |
> | help [tablename]                      |
> | quit                                  |
> |                                       |
> +---------------------------------------+
>
> But I can't anderstand why the same config (odbc.ini & odncinst.ini)
> doesn't work with other client such libreoffice base or R.
> Actually the problem appens with oracle and not with mysql..
>
> Both case i have the error :
> app/oracle/product/11.2.0/xe/lib/libsqora.so.11.1' : file not found
>  But the file exists and isql doesn't have problem to find it.
>
>
> Normally the problem is that a file that libsqora depends on is either
> missing or not in the lib search path. Often the simple way is to use
> truss/strace or what your platform has to see what libs are being loaded
> and what libs fail to load.
>
> --
> Nick
>
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at mailman.unixodbc.org
> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20130625/17edc955/attachment.html>


More information about the unixODBC-support mailing list