How to connect SAP Hana database using C#

[makhamadzoidov]

Hello 

I need to connect SAP hana database using C# but I can't do it. I wrote python it connect successfully but in C# I can't do it.

Here this is python code. This code works good. I need to connect to server using my own local computer. (I don't have sap b1 app and sap hana app in my computer). Please write C# code to connect sap hana from local computer using C#.

import warnings
from hdbcli import dbapi

warnings.filterwarnings("ignore")

sap_db = "DATABASE_NAME"
address = "SERVER_IP_ADDRESS"
conn = None

try:
    conn = dbapi.connect(
        address=address,
        port='PORT',
        user='SYSTEM',
        password='PWD',
    )
    # If no errors, print connected
    print('connected')

    # conn.close()
except Exception as e:
    conn.close()
    print(str(e))
    sys.exit('Query failed......')

[Sandra_Rossi]

Your code is incorrectly presented in one line. Here it is, better presented:

import warnings from hdbcli
import dbapi

warnings.filterwarnings("ignore")
sap_db = "DATABASE_NAME"
address = "SERVER_IP_ADDRESS"
conn = None
try:
    conn = dbapi.connect(
        address=address,
        port='PORT',
        user='SYSTEM',
        password='PWD',
    )
    # If no errors, print connected
    print('connected')
    # conn.close()
except Exception as e:
    conn.close()
    print(str(e))
    sys.exit('Query failed......')

[makhamadzoidov]

Thanks a lot. Do you know how to connect with C#?

[ANKIT_CHAUHAN · Accepted solution]

Hi makhamadzoidov,

Kindly refer to the following post: Creating a C# Application Using SAP HANA and ADO.NET 

Hope it helps!

Kind regards,

ANKIT CHAUHAN

SAP Business One Support