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?