I have a colleague that has successfully made a remote connection to a CCX server using SQuirrel.
I am attempting to make a remote connection to the same CCX server using python and the ibm_db library. Is it possible to make such a connection using python? My goal is to obtain "inboundseatsinuse". See below screenshot.
When attempting to connect I get the following exception.
Exception: [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "192.168.192.173". Communication function detecting the error: "recv". Protocol specific error code(s): "*", "*", "0". SQLSTATE=08001 SQLCODE=-30081
I have found information regarding this error code.
Information about the exception can be found here and here.
The redacted Python command is as follows:
>>> ibm_db.connect("DATABASE=db_cra;HOSTNAME=192.168.192.173;PORT=1504;PROTOCOL=TCPIP;UID=uccxhruser;PWD=<password>", "", "")
I have verified network and port connectivity to the CCX server.
