Skip to Content
author's profile photo Former Member
Former Member

issue with local odbc connection

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 ?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 11, 2014 at 04:41 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 06, 2014 at 10:20 PM

    Hi,

    Has anyone faced this issue before ?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.