Skip to Main Content
Forums

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

isql | unixODBC | Driver Manager can't open lib "libsqora.so.12.1"

DanielHPOct 20 2013 — edited Oct 22 2013

hi all...

i try to acces oracle from postgre..

i use ODBC..

first i try to acces oracle from isql and i got error that driver manager can't open libsqora.so.12.1

this is my configuration

odbc.ini

[XE]


Description     = Oracle ODBC


Driver          = XE


Trace           = yes


TraceFile       = /tmp/odbc_oracle.log


Database        = //192.168.102.202:1521/XE


UserID          = system


Password        = password


Port            = 1521

odbcinst.ini

[XE]


Description = Oracle ODBC Connection Driver


Driver      = root/download/odbc/instantclient_12_1/libsqora.so.12.1


Debug       = 0


CommLog     = 1

tnsname.ora

XE =


  (DESCRIPTION =


    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.102.202)(PORT = 1521))


    (CONNECT_DATA =


      (SERVER = DEDICATED)


      (SERVICE_NAME = XE)


    )


  )

then, when i use isql to acces oracle i got that error:

[root@oracle-poc ~]# isql -v XE


[01000][unixODBC][Driver Manager]Can't open lib 'root/download/odbc/instantclient_12_1/libsqora.so.12.1' : file not found


[ISQL]ERROR: Could not SQLConnect

whats wrong with my configuration, can anyone help me??

thanks,

Daniel

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 19 2013
Added on Oct 20 2013
#11g, #heterogeneous-connectivity, #linux, #odbc
13 comments
57,215 views