Cannot connect to an Hana database via its ODBC driver

0 votes

1 answer

6159 views

                          I have not found any documentation about *ODBC* connection strings for *Hana* and am trying to connect using the [examples](https://help.sap.com/viewer/0eec0d68141541d1b07893a39944924e/2.0.00/en-US/66a4169b84b2466892e1af9781049836.html)  in *SAP HANA Database Client Interfaces*.

An attempt to connect via *ODBC* with the connection string:

    DRIVER=HDBODBC; SERVERNODE=192.168.0.213:30015; ID=SYSTEM; PWD=PASSWORD;

fails with this error:

    ERROR [08S01] [SAP AG][LIBODBCHDB DLL][HDBODBC]
    Communication link failure;
    -10709 Connection failed (RTE:  (192.168.0.213:30015))

whereas the corresponding *ADO.NET* connection works:

    Server=192.168.0.213:30015;UserName=SYSTEM;Password=PASSWORD;

What may be wrong with the *ODBC* connection? I have the correct driver installed.

Asked by Anton Shepelev (248 rep)

Dec 24, 2018, 09:22 AM
Last activity: Apr 10, 2019, 05:50 AM

Cannot connect to an Hana database via its ODBC driver

Related Questions