CODEWITHSUNDEEP
vbaexcelconnection-stringhana
Deepak Tiwary
Deepak Tiwary

Reputation: 120

ODBC connection string for multi-tenant HANA database

What will be the connection string that can be used in EXCEL VBA to connect to multi-tenant HANA database ? Currently I am using the string mentioned below but getting 10709 error:-

connectionstring = "Driver=HDBODBC;SERVERNODE=10.20.30.40:30015; DATABASENAME=ABCDE;CS=DBO"

Upvotes: 2

Views: 4425

Answers (1)

Lars Br.
Lars Br.

Reputation: 10396

To connect to the tenant you're interested in, you need to provide the correct port number. E.g. 30045 if the overall instance no. is 00.

The whole port assignment scheme is explained in detail in the "SAP HANA Multitenant Database Containers Operations Guide" chapter 2.9 Connections for Multitenant Database Containers

Upvotes: 3

Related Questions