[unixODBC-support] How to connect to Oracle Express via unixODBC?

Nick Gorham nick at lurcher.org
Thu May 7 15:35:31 BST 2009

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.

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.


More information about the unixODBC-support mailing list