HANA ODBC Connection

[Former Member]

Hi experts,

I tried to use the below commands to form a connection string to HANA database from an Add-On.

Dim conn As DbConnection = Nothing

Dim _DbProviderFactoryObject As DbProviderFactory

Dim connStr As String = "DRIVER={HDBODBC32};UID=SYSTEM;PWD=B1aAdmin;SERVERNODE=192.168.1.99:30015;DATABASE=SYSTEM"

Dim ProviderName As String = "System.Data.Odbc"

_DbProviderFactoryObject = DbProviderFactories.GetFactory(ProviderName)

conn = _DbProviderFactoryObject.CreateConnection()

conn.ConnectionString = connStr

conn.Open()

However it returns the following exception.

System.Data.Odbc.OdbcException: ERROR [HY000] [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] Gene

ERROR [HY000] [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] Gene

   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)

   at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)

   at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions)

   at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

   at System.Data.Odbc.OdbcConnection.Open()

   at Service_SDK.SubMain.Main() in C:\Service\SubMain.vb:line 240

Does anyone have hints on this issue? Do I need to add any reference to the add-on solution in order to make the connection works?

Best regards,

Krisma

[Former Member]

I'm getting this error in an application that was previously working.

We recently upgraded our HANA database to SPS9 and that perhaps the old HANA client software needs to be updated.

What version of HANA are you using? Could your client software be out of date?

[AtulKumarJain]

Yes Michael,

You need to upgrade your HANA client as well.

BR

AKJ