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:

autocommit    : ON

The DSN configuration is this:


Description="SmartCloudPT HANA"





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


Description = "SmartCloudPT HANA"


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

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.



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