on 05-09-2017 4:09 PM
Hi,
I cannot connect to any tenant database using ODBC. I can connect to the System database (Port 39013). Any attempt to connect on port 39015 fails
On a related note, my attempts to create a connection with IDT using JDBC also fail (The connection is also made through port 39015). I can shoehorn port 39013 by selecting "Multi Server" as data source, but here again I can only connect to the System database.
Any suggestions?
Hi Frank,
I have tried your suggestion (In my case the port in question is 39040, but I still can't establish an OBBC connection to database other than System.
The interesting thing is, I can write a small Java program to connect to my tenant database with the following connection string:
jdbc:sap://hxehost:39013/?databaseName=HANA
So it seem that 39013 is the port to connect to, though so far I have not been able to connect to a tenant database other than via by Java code, or using Hana Studio. Every other client tool will not let me access a tenant database (Only System)
Cheers,
Eric
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Eric,
Were you able to connect to the tenant DB via the studio, i am facing the same issue .
Thanks
Anthony
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Eric,
I am afraid you are trying to connect to the wrong port. The SQL/MDX acces port for standard access to the tenant database of a multitenant HANA system is in the range of 3NN41 - 3NN98 (see TCP/IP Ports of All SAP Products).
You can find this port from your SAP HANA Studio. In my case it is 30041:
Best regards
Frank
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.