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

Connecting DotNet to SAP HANA: Not using ODBC

Posted on May 11, 2015 at 11:52 AM 877 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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

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

    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 a comment
    10|10000 characters needed characters exceeded

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

    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 a 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
    0

    Please take a view on my reply on same post

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.