DSXchange

Hi ,
I am trying to connect to HANA database through data stage. I have installed hana client in my AIX sever . I have added the following in .odbc.in file .

[HANA]
Driver=/usr/sap/hdbclient/libodbcHDB.so
DriverUnicodeType=1
Description=Hana Conntion Test
HostName=19.51.189.12
LogonID=USERNAME
Password=PASS
PortNumber=30015
LoginTimeout=-1
QueryTimeout=-1
ConnectionRetryCount=3

Update the uvodbc.config
<HANA>
DBMSTYPE = ODBC

Connectivity TEST
./bin/dss
DataStage Command Language 9.1 Licensed Materials - Property of IBM
(c) Copyright IBM Corp. 1997, 2012 All Rights Reserved.
DSEngine logged on: Thursday, January 15, 2015 10:27

>LOGTO dstage1
>DS_CONNECT HANA
Enter username for connecting to 'HANA' DBMS [dsadm]: USERNAME
Enter password for USERNAME:PASS
SQLConnect error: Status = -1 SQLState = 08S01 Natcode = -10709
[ODBC] [SAP AG][LIBODBCHDB SO][HDBODBC] Communication link failure;-10709 Connection failed (RTE:[89006] System call 'connect' failed, rc=79:Connection refused)

Can you guys help . What is the issue i am having ?
Thank in advance

You mentioned you had installed a Hana client on your AIX server. Have you tried connecting from the AIX command line, via that client, with the same ID and password, with success? The ODBC error you got looks pretty generic, so it could be caused by any number of things.

You may also need to make sure that the HANA libraries directory(ies) are in your libpath environment variable (or SHLIB_PATH?... depends on your OS)