Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

unixodbc to HANA - DSN configuration

I am trying to connect to HANA on the same system using unixodbc on SUSE 11. Everytime I execute isql -v hanacloud SYSTEM passwd I get following error:


isql -v hanacloud SYSTEM passwd

[08S01][unixODBC][SAP AG][LIBODBCHDB SO][HDB] Communication link failure;-10709 Connect failed (no reachable host left)

[ISQL]ERROR: Could not SQLConnect

I can successfully connect using hdbsql:


./hdbsql -n hanabox:30015 -u SYSTEM -p secret

Welcome to the SAP HANA Database interactive terminal.

Type:  \h for help with commands

       \q to quit

hdbsql=> \s

host          : hanabox:30015

database      : HDB

user          : SYSTEM

kernel version: 1.00.39.369298

autocommit    : ON

The DSN configuration is this:


[hanacloud]

Description="SmartCloudPT HANA"

Driver=HDBODBC

ServerNode=hanabox:30015

User:SYSTEM

Password:secret

The drivers file (/etc/unixODBC/odbcinst.ini) is this:

[HDBODBC]

Description = "SmartCloudPT HANA"

Driver=/usr/sap/hdbclient/libodbcHDB.so


The problem is, anything I put into ServerNode line in odbc.ini file (also when I delete this line at all), the returned error is 'no reachable host left'. What does it exactly mean and how can I configure my DSN to connect to this database?

The driver version is SAP HANA Database Client 1.00.38.368649


Interestingly, I can sucessfully connect with unixodbc/isql to the same database from another (Ubuntu) box, so I'm sure that database is running and all required ports are open. The DSN and drivers files on this Ubuntu box are the same as on my SUSE box.

I'm fighting with that for second day and I have no ideas left.

regards,

Marcin

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question