on 08-06-2012 9:00 PM
I am trying to connect to HANA from unixodbc on Linux (ultimately to connect from Python). Can't get it work. Any hints?
Thanks,
Tobias
I can successfully connect using hdbsql
oberstet@ubuntu10bld_klon0:~/hana$ hdbsql -n 54.204.111.7: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 : imdbhdb:30015
database : HDB
user : SYSTEM
kernel version: 1.00.28.361821
autocommit : ON
hdbsql HDB=> \q
Using unixodbc it fails:
oberstet@ubuntu10bld_klon0:~/hana$ isql HANA SYSTEM secret -v
[08S01][unixODBC][SAP AG][LIBODBCHDB32 SO][HDB] Communication link failure;-10709 Connection failed (RTE:[89006] System call 'connect' failed, rc=111:Verbindungsaufbau abgelehnt)
[ISQL]ERROR: Could not SQLConnect
The DSN configuration is this:
oberstet@ubuntu10bld_klon0:~/hana$ cat /etc/odbc.ini
[HANA]
Description = ODBC for SAP HANA
Driver = /usr/sap/hdbclient32/libodbcHDB32.so
Host = 54.204.111.7
Port = 30015
Ok, figured it out (this really needs to be documented .. lost 2 hours trial and error):
oberstet@ubuntu10bld_klon0:~/hana$ cat /etc/odbcinst.ini
[HANA]
Description = ODBC Driver for SAP HANA
Driver = /usr/sap/hdbclient32/libodbcHDB32.so
Then:
oberstet@ubuntu10bld_klon0:~/hana$ cat test.py
import pyodbc
conn = pyodbc.connect('DRIVER={HANA};SERVERNODE=54.204.111.7:30015;SERVERDB=HDB;UID=SYSTEM;PWD=secret')
cur = conn.cursor()
cur.execute("select * from test1.t1")
print cur.fetchall()
===
I was only able to figure out the correct connection string by reverse eng. of /usr/sap/hdbclient32/odbcreg32, which seems to be some test tool.
I was not able to setup a correct, usable DSN. Only via above (direct connection string).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tobias,
Thanks for the post.
Replying here for those that are still reading your post as a result of a Google search. Just uploaded a video to the SAP HANA SPS 08 installation playlist: https://www.youtube.com/watch?v=whQTt0guROA&index=7&list=PLkzo92owKnVzjry75ID3mydr6VGX2Ul9M
In this video, I address the ins and outs of HANA ODBC on Linux. Since SPS 02, ODBC also has been documented in the SAP HANA developer guide (chapter 13).
Denys van Kempen, SAP HANA Academy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.