Configure the odbc to connect oracle database on linux

[Former Member]

I am trying to do such a demo :

Sync the data from sql anywhere to oracle, so the consolidated database is oracle.

I configured the .odbc.ini like the following:
[ODBC Data Sources]

MyOracleDSN=SQLAnywhere 17.0

[MyOracleDSN]

UserID=DBAUSER

Password=sybase

ProcResults=y

ArraySize=500

ServiceName=ORCL

Driver=/home/asa17/lib64/libdboraodbc17_r.so

And then when I tried to connnect oracle database,it said:

dbisql -c "dsn=MyOracleDSN" -nogui

  Could not connect to the database.

  Unable to load driver /home/asa17/lib64/libdboraodbc17_r.so

  SQLCODE=-620, ODBC 3 State="IM003"

When I tried to setup a remote server, it reported the same error:

  (DBA)> create server ora_remote class 'oraodbc' using 'MyOracleDSN'

  (DBA)> create externlogin DBA to ora_remote remote login DBAUSER identified by sybase

  (DBA)> create existing table proxy_test at 'ora_remote...test'

     Could not execute statement.  

     Unable to connect to server 'ora_remote': [SAP][ODBC Driver Manager] 

     Unable to load driver /home/asa17/lib64/libdboraodbc17_r.so  

     SQLCODE=-656, ODBC 3 State="HY000" 

      Line 1, column 1 

      create existing table proxy_test at 'ora_remote...test'

The demo environment:

Suse11 sp3 64bit

SQL Anywhere 17 64bit for linux

I have not any idea why this happened : Unable to load driver /home/asa17/lib64/libdboraodbc17_r.so

Appreciate for any comments.

[former_member207653 · Accepted solution]

https://www.suse.com/documentation/sles10/book_sle_reference/data/sec_util_debugging.html

You could try to run:

ldd /home/asa17/lib64/libdboraodbc17_r.so

to find out which libraries would load

[Former Member · Accepted solution]

Thanks Mirco. I had found the right answer: http://sqlanywhere-forum.sap.com/questions/22094/oracle-driver-odbc-linux-mobilink It must create a soft link for oracle library :libclntsh.so.[VERSION].for example, for the Oracle 11:  ln -s libclntsh.so.11.1 libclntsh.so.