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
host : hanabox:30015
database : HDB
user : SYSTEM
kernel version: 1.00.39.369298
autocommit : ON
The DSN configuration is this:
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 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.