Is there a way to connect with company Db using connection string in SAP B1 HANA.

[former_member308324]

I want to connect with company database using connection string. (standard .net connectivity with database)

[ANKIT_CHAUHAN]

Hi mubashar.hameed,

Refer to the following discussion. It contains the example that you are looking for.

https://answers.sap.com/questions/13110292/sap-buisness-one-rel-10-new-server-format.html

Hope it helps!

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[edy_simon]

Hi,

Yes, install SAP HANA Client for the correct platform and reference the Extensions.
Use it as you would with System.Data.SQLClient

        Dim connStr As New Sap.Data.Hana.HanaConnectionStringBuilder()
        connStr.Server = "serverName:30015"
        connStr.UserName = "_userName"
        connStr.Password = "_pass"
        connStr.CurrentSchema = "SBODemo"


        Dim _conn = New Sap.Data.Hana.HanaConnection(connStr.ConnectionString)
        _conn.Open()

Regards
Edy

[former_member308324]

Hi,
Thanks Edy.
I am using the same 4.5. but i am not sure about the params to use in connection string.
I would be great if you can provide me a sample/ref.

[edy_simon]

Hi,
Updated my answer with a sample.

Regards
Edy