Python and HCP Trial connectivity issue.

[Vigneshbosch]

I am trying to establish a connection with my HCP trail account from python but facing the below issue:

The code snippet i used to establish this connection is :

import dbapi

conn = dbapi.connect( 'hanatrial.ondemand.com' , 30015, 'p1942054738', 'xxxxxx')

print ( conn.isconnected())

Please note :

• i have placed this code under python folder of hdbclient.

• I have copied these files into the Lib folder of python

        * __init__.py, dbapi.py, resultrow.py
  
        * pyhdbcli.pdb, pyhdbcli.pyd
  

Please let me know what am i missing to establish a connection between HCP and python.

[ghost]

Take a look here:

https://blogs.sap.com/2015/04/24/try-hanatrial-using-python-or-nodejs/

[timogasda]

Please note that this repository is not about the HANA connector that ships with HANA, which you seem to be using.

[Vigneshbosch]

@iivanov-hub
Thanks for the response the blog was useful but the open-db-tunnel doesn't provide me with a user name and password.

Please let me know if i am missing something ?

@TwoLaid
I even tried with the pyhdb library still no luck. The connection gets timed out.

[ghost]

Once you have tunnel up and running, you have to use your database user and password, SYSTEM for example. host is "localhost" and port is 3015, based on output from your command output.

[timogasda]

I've never worked with a HCP trial instance, but maybe refer to this thread: SAP/node-hdb#1

It is for the NodeJS connector but the logic might be applicable here as well

[jarus]

Sorry for the late response. If the issue still persist then please feel free to reopen the issue. I would also recommend to contact the HCP/SCP support as it looks like a problem related with the HCP/SCP proxy.