DSN less connection to HANA DB using python not woriking

[former_member42822]

I installed HDBODBC32 driver and connected to HANA DB using a DSN, then by using the DSN in my pyhton code i was able to access the DB

However when i tried to give the connection information in the connections string itself without DSN im getting the below error

Error: ('08S01', "[08S01] [SAP AG][LIBODBCHDB32 DLL][HDB] Communication link failure;-10709 Connection failed (RTE:[89006] System call 'connect' failed, rc=10061:No connection could be made be (-10709) (SQLDriverConnectW)")

Below is my code

pyodbc.connect('DRIVER={%s};SERVER =%s;DATABASE=%s;UID=%s;PWD=%s'%(driver,server,database,userid,pswd))

Where the driver is "HDBODBC32"

server is server ="xxxx:3xx15"

DATABASE = "HDB"

Could anyone help me on this....

[Former Member · Accepted solution]

Hi Vinoth,

I am not a python developer, but could it be the ServerNode?

Check the connection string in this post.

http://scn.sap.com/docs/DOC-33628

[former_member42822]

Thank you Michael ,

It works fine now after changing it to ServerNode...

[Former Member]

Awesome! I know that and I will both be eager to see some more on what you are able to do with python and HANA. Please blog about your results!

Cheers,

David.

[former_member182779]

Totally! I would love to see more Python/HANA content

Greetings,

Blag.