SAP Hana C# Connection is not working

410 Views Last edit Jun 28, 2019 at 04:17 PM 2 rev

Hi, I am currently developing a Solution to connect C# to SAP Hana but it is not working, I already found several forums with the potential solutions but it is still not working.

This is my connection, in fact I am trying with 2 different connection strings

Connection = "DRIVER =HDBODBC; UID =USER; PWD =PASSWORD; SERVERNODE =host:30015";
Connection = "Server=host:30015; UID=USER; PWD=PASSWORD");
HanaConnection conn = new HanaConnection(Connection);

in both cases I have the same result, the error message: SAP HANA Data Provider for Microsoft ADO.Net : authentication failed (10).

I guess this is related to the kind of user cause I used the same credentials directly in SAP and it gives the error message Logon with a dialog user. I was told this is a sap. can you help me to get a connection for this kind of user?

thanks!