Skip to Content
0
Former Member
Apr 07, 2014 at 07:48 AM

HANA Connection String

2931 Views

Hi experts,

I'm trying to create a class to do a direct connection for other application to HANA database, unfortunately I'm still new in HANA studio and I need your advice on the below.

From the sample I got, the format of HANA connection string should be as follow.

Dim connStr As String = "DRIVER={HDBODBC32};UID=SYSTEM;PWD=PASSWORD;SERVERNODE=192.168.1.11:30015;DATABASE=SBOCOMMON"

Can anyone advise where should I get the SERVERNODE parameter value?

I saw in the Properties of the root node (NDB) - Additional Properties - Host : 192.168.1.11:30015, is this the 'ServerNode' that the connection string referring too?

I tried to make this class as reference from VB applications in the future, I can manage to pass the UID and Password, but how to make the connection string to be flexible enough to get current ServerNode so I won't need to change the connection string and recompile the class everytime I'm going to use it as reference to other application?

Please enlighten me..

Thanks and best regards,

Krisma