Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to create ODBC DSN(for local database as well as for remote database) on Linux for Oracle 11.2g

5f4b63cc-16e0-4888-80ee-33ee5d5c50d1Oct 5 2015 — edited Oct 5 2015

Hi All,

I am new to the databases and for Linux environment. I want to create odbc DSNs on linux machine for oracle database installed locally or on remote system. I tried various options to setup a DSN for local oracle database(I'm using Oracle 11.2g XE). But I am getting following error while creating Oracle DSN on linux.

isql -v oracle

output:

[01000][unixODBC][Driver Manager]Can't open lib '/u01/app/oracle/product/11.2.0/xe/lib/libsqora.so.11.1' : file not found

[ISQL]ERROR: Could not SQLConnect

I have given read, write, execute(777) permissions to this library. But still I am receiving above error.

Can anyone provide me pointers to resolve the issue or provide me complete steps to configure the DSN. Any help will be appreciated.

Thanks,

Omkar

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 2 2015

Added on Oct 5 2015

1 comment

934 views