HANA Database Connection Error

[former_member727323]

I am new to HANA database and am attempting to make a connection from either python or SQL. With the set of username and password set in the python connection file is correct and can be used to log in to HANA explorer. Yet when I run the file on the local machine, it returns the below error:

hdbcli.dbapi.Error:
(-10709, 'Connection failed (RTE:[1000013] wrong provider for this platform
(zeus.hana.canary.eu-central-1.whitney.dbaas.ondemand.com:41587))')

I also tried to run this command on HDBSQL:

hdbsql -n zeus.hana.canary.eu-central-1.whitney.dbaas.ondemand.com:41587 -u ... -p ... -e

Even though username and password are specified in the command, the system still requests entering username and password again.

And then I got the error below:

-10709: Connection
failed (RTE:[89006] System call 'connect' failed, rc=10061:No connection could
be made because the target machine actively refused it (localhost:30015))

Anything I've missed? Package versions:

hdbcli==2.7.21
hdbsql==2.7.17.1607722875

[dvankempen]

Got the answer to your question? To improve the knowledge base and make the right answers easier to find, please mark the best answer and close the question. Thanks!

Don’t know how? See Ask and Answer Questions on SAP Community

For the readers, before you leave, don't forget to up/down vote the answers. You can vote on the question too.

Thanks.

[BitanC]

Hello Wanchen,

The error text is bit generic and there can be multiple reasons behind that. But it is clear that by any of the reasons your provided string is not able to connect the HANA server.

You may check one by one like below

hostname is reachable from your client

hostname:port combination are not blocked by security policies

the provided port is sql port and correctly mentioned

mention -d to specify tenant

please take a look on below for details of hdbsql

Log On to a Database - SAP Help Portal

Hope this helps.

Thanks,

Bitan