How do I connect to SAP HANA from .NET without installing driver on the web server

[former_member609025]

We have an application that uses SAP HANA as the backend database and a .NET UI. We are connecting .NET to HANA db via ADO driver and the driver is installed on the web server. We moving to a different architecture/design where we will NOT be able to install ADO or any other driver on the web server. We would like what options we have to be able to connect our .NET UI to HANA db ?

One thing we tried was - without installing the driver on the server, we added .dll to the .NET solution as a reference but it did not work for us. We received the error below -

System,.IO.FileNotFoundException: Cannot find libSQLDBCHDB.dll

Any help is much appreciated.

Thanks!

[former_member241108]

Why not create REST API service at HANA side, consume this service at your DOT NET web application.