[unixODBC-support] Connecting to Oracle Express

Ken Resander kresander at yahoo.com
Thu May 7 18:13:25 BST 2009

Many thanks for your super-fast response.

Yes, the lib in the Drivers line exists.

As an old Windowser currently migrating to Ubuntu I am not yet too hot on the Linux command line. For example, did not know about the ldd command, but read the manual and issued it with alacrity:

ken at ken-desktop:~$ ldd /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libsqora.so.10.1
    linux-gate.so.1 =>  (0xb7fba000)
    libdl.so.2 => /lib/tls/i686/cmov/libdl.so.2 (0xb7f0c000)
    libm.so.6 => /lib/tls/i686/cmov/libm.so.6 (0xb7ee6000)
    libpthread.so.0 => /lib/tls/i686/cmov/libpthread.so.0 (0xb7ecc000)
    libnsl.so.1 => /lib/tls/i686/cmov/libnsl.so.1 (0xb7eb3000)
    libclntsh.so.10.1 => not found
    libodbcinst.so.1 => /usr/lib/libodbcinst.so.1 (0xb7ea6000)
    libc.so.6 => /lib/tls/i686/cmov/libc.so.6 (0xb7d48000)
    /lib/ld-linux.so.2 (0xb7fbb000)
    libltdl.so.7 => /usr/lib/libltdl.so.7 (0xb7d3e000)

ldd reports libclntsh.so.10.1 => not found, but it exists as shown by:

ken at ken-desktop:~$ locate libclntsh.so.10.1 

in the same directory as libsqora.so file.

Don't understand how to interpret this.


P.S. I have googled on '.../libsqora.so.10.1 missing' and there are several matches, but none helped. One or two replies suggested the LD_LIBRARY_PATH environment needs to be set. I thought this variable is for the linker only. Is it used by the runtime support also?

P.P.S.  If I click the Reply button will my post go to the forum list (which is what I want)? or will it go to yourself as a private message?

Nick wrote:

Is the entry in the Drivers line the same as a lib that exists?


ldd /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libsqora.so.10.1

to see if there are other dependednt libs missing.


Ken Resander wrote:

>I am moving ODBC-dependent code from Windows to Ubuntu 8.10. All software has recompiled ok and the unixODBC interfaces work for DB2 Express 9.5, Mimer SQL and MySQL, but not yet for for Oracle Express 10g and SQL Anywhere.
>I posted the question 'How to use unixODBC with Oracle Express on Ubuntu 8.10?' on Oracle's Linux forum a couple days ago, but have not received any response. 
>I am posting in this forum hoping for better luck.
>Here is the Oracle Linux forum post:
>++++ post starts +++
>I downloaded Oracle Express a couple of days ago, so I am totally new to Oracle.
>I tried connecting via unixODBC, using dsn=oracledsn, user=dba, password=abcd and received error info:
>1: st=01000, nerr=0, msg=
>[unixODBC][Driver Manager] Can't open lib '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libsqora.so.10.1' : file not found
>but the shared 'so' library actually does exist at the path above. I also set
>ODBCINI=/etc/odbc.ini;export ODBCINI and immediately checked it was in the environment.

      New Email names for you! 
Get the Email name you've always wanted on the new @ymail and @rocketmail. 
Hurry before someone else does!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20090507/a8a9ec85/attachment.html>

More information about the unixODBC-support mailing list