Skip to Content
author's profile photo Former Member
Former Member

Connecting DotNet to SAP HANA: Not using ODBC

Posted on May 11, 2015 at 11:52 AM 623 Views

Hi,

I cam across this article which states that for efficiency purposes its better to use ADO.NET driver instead of ODBC to connect dotnet with HANA.

http://scn.sap.com/community/developer-center/hana/blog/2014/10/16/bridging-the-gap-between-net-and-hana-using-c

The article says "To start using the new ADO.NET API delivered in SPS 08, you will need to have the latest SAP HANA Client Developer Edition version 1.00.80 installed on your machine or alternatively check the default installation path under C:\Program Files\sap\hdbclient\ado.net. If you have that installed, you should see two folders call v3.5 and v4.5 and clicking through v4.5, you should have the Sap.Data.Hana.v4.5.dll."

We already have SAP HANA studio installed on our machines. So will installing the Client Developer Edition cause conflicts?

Basically we need to place the Sap.Data.Hana.v4.5.dll file at a suitable location because that seems to be the driver to connect dotnet with HANA.

Has someone done this manually instead of installing Client Developer Edition or we just have to install the SAP HANA Client Developer Edition version ?

Thanks,

Samarjit

SAP HANA
Add comment
10|10000 characters needed characters exceeded

3 Answers

  • author's profile photo Lars Breddemann
    Lars Breddemann
    Posted on May 12, 2015 at 07:55 AM

    The SAP HANA Studio installation is completely isolated from any other SAP HANA software on your computer.

    You can safely install the client software to get the ADO.NET driver.

    Don't try to fiddle with the single files though - the client software installation is supposed to work as it gets installed.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Jun 15, 2016 at 10:43 AM

      Hi Samar,

      Have you tried creating a x64 build-profile in Visual Studio?

      This solved the issue for us without the need to install the 32-bits version of the SAP HANA tools.

      Cheers,

      Frank

  • author's profile photo Former Member
    Former Member
    Posted on May 12, 2015 at 07:09 AM

    Update: even after installing the Client Edition, using the command "hdbinst", we are still getting the following error:

    "Cannot find libSQLDBCHDB.dll"

    We even included the path of installation "C:\Program Files\sap \hdbclient" to the PATH environment variable..

    Somehow the visual studio is not finding that dll.

    Any clues?

    Thanks!

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Juan de la Cruz Arellano Royo
    Juan de la Cruz Arellano Royo
    Posted on Aug 04, 2016 at 03:18 PM

    Please take a view on my reply on same post

    Regards

    Add comment
    10|10000 characters needed characters exceeded