Exception: [IBM][CLI Driver] SQL30081N

[Denis Kharlap]

Greetings!

I'm trying to connect from Debian 7 to remote Informix DB 11.70 (openSUSE 12.1) using ibm_db 2.0.5.1 but i've got the following error:

Traceback (most recent call last):

  File "dbinf.py", line 6, in <module>

    connect = ibm_db.connect(dsn, '', '')

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: "10.247.221.115".  Communication function detecting the error: "recv".  Protocol specific error code(s): "*", "*", "0".  SQLSTATE=08001 SQLCODE=-30081

The connection string is:

"DATABASE=dbname;HOSTNAME=10.247.221.115;PORT=9088;PROTOCOL=TCPIP;UID=usr;PWD=pwd;"

If change protocol to SOCKETS the error is:

Exception: [IBM][CLI Driver] SQL1013N  The database alias name or database name "" could not be found.  SQLSTATE=42705 SQLCODE=-1013

Python 2.7.3, 64 bit

Thanks in advice.

[Włodek Futrega]

The connection string is:

"DATABASE=dbname;HOSTNAME=10.247.221.115;PORT=9088;PROTOCOL=TCPIP;UID=usr;PWD=pwd;"

 

It looks like you are trying to connect to the standard informix port.

To use ibm_db you have to define drda connection.

Example from my sqlhosts:

onlinedr        drsoctcp     drhost  9099

[Denis Kharlap]

Thanks for help, will try this.