issue with local odbc connection

[Former Member]

Hi Folks,

We have installed hdbclient and unix odbc according to the video,http://www.saphana.com/docs/DOC-4541

But the problem is that when i create a new DSN as below and try to connect it gives me the below error.

<hostname>:~> more .odbc.ini

[<DSN>]

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

ServerNode=<AWS elastic IP>:30015

<hostname>:/usr/sap/HDB/HDB00> isql -v <DSN> SYSTEM password

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

[ISQL]ERROR: Could not SQLConnect

I have given the same elastic ip address and also used the hana instance id from aws as the dsn name but still i get this error.

HDB version info:

  version:             1.00.70.00.386119

  branch:              NewDB100_REL

  git hash:            not set

  git merge time:      not set

  weekstone:           0000.00.0

  compile date:        2013-11-29 15:58:05

  compile host:        xxxxxx.wdf.sap.corp

  compile type:        opt

HANA client has already been installed.

No  | Installation Path                    | Version           | Mode

----------------------------------------------------------------------

[0] | /usr/sap/hdbclient                   | 1.00.73.00.389160 | 64bit

Any inputs as to what might be reason for this error ?

[Former Member · Accepted solution]

use Strace to get where the location odbc refer to and create a link to it.

It could be eiher /etc/unixODBC or /usr/local/etc

Details on this source: SAP HANA Academy - SAP HANA installation: 7. HANA ODBC on Linux - YouTube

[Former Member · Accepted solution]

We had many problems decided to give up and went for a reimage.

[Former Member · Accepted solution]

closing the thread since its been many days.

[Former Member]

Hi,

Has anyone faced this issue before ?

[Former Member]

Has anyone faced issue while installing or configuring odbc drivers on sap hana box or appliance.