Doesn't connect to Informix when DBeaver succeeds

[Nikola Toshev]

Hello,

I'm trying to connect to an Informix database without success. 

>>> ibm_db_dbi.connect("DATABASE=udqa;HOSTNAME=myhost;PORT=40013;PROTOCOL=TCPIP;UID=user;PWD=password;","","")

ibm_db_dbi.OperationalError: ibm_db_dbi::OperationalError: [IBM][CLI Driver] SQL30081N  A communication error has been detected. Communi

cation protocol being used: "TCP/IP".  Communication API being used: "SOCKETS".  Location where the error was detected: "10.100.100.100".

  Communication function detecting the error: "recv".  Protocol specific error code(s): "*", "*", "0".  SQLSTATE=08001 SQLCODE=-30081

The port on that host is open and I can connect successfully with DBeaver. The JDBC connection string is:

jdbc:informix-sqli://myhost:40013/pct:INFORMIXSERVER=udqa

I also tried DATABASE=pct instead of udqa and ibm_db module instead of ibm_db, but it doesn't make a difference.

Any idea what might be wrong?

Thank you in advance,

Nikola

[Saba Kauser]

Hello Nikola,
Is this port 40031 correct where your server is listening for connections from client? Is it the intended drda port ?

[Nikola Toshev]

Thank you for the reply, Saba. It is definitely the port server is listening for connections from Java clients like dbeaver. Not sure if this is a drda port and what this means. Is there a way to test for this? I'm not getting much support from the server admins.

Thanks and regards,

Nik

--
You received this message because you are subscribed to the Google Groups "ibm_db" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ibm_db+unsubscribe@googlegroups.com.
To post to this group, send email to ibm...@googlegroups.com.
Visit this group at https://groups.google.com/group/ibm_db.
For more options, visit https://groups.google.com/d/optout.

--

Nikola Toshev

CTO
Sciant AD
 
mobile: +359 899 100701
e-mail: n...@sciant.com

[Nikola Toshev]

Ports 40010-40013 are all open ports on that machine, and trying to connect to any of them returns the same error. I'm using ibm_db on a Linux machine. There is no informix client sdk installed there - do I need one?

Thanks,

Nikola

[Saba Kauser]

Hello Nikola,
I haven't ever tried configuring connections to Informix. I found these links:
https://www.ibm.com/support/knowledgecenter/en/SSGU8G_11.50.0/com.ibm.admin.doc/ids_admin_0207.htm
https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.admin.doc/ids_admin_0207.htm

Can you see if these help you go somewhere.

Thanks,
Saba.

[Nikola Toshev]

Thanks Saba, I found a way to avoid the necessity to connect to informix (exported the relevant data). If I had to make it work, I think I'd try https://pypi.org/project/JayDeBeApi/  

Best rgards,

Nikola

To unsubscribe from this group and stop receiving emails from it, send an email to ibm_db+un...@googlegroups.com.

To post to this group, send email to ibm...@googlegroups.com.
Visit this group at https://groups.google.com/group/ibm_db.
For more options, visit https://groups.google.com/d/optout.

--

Nikola Toshev

CTO
Sciant AD
 
mobile: +359 899 100701
e-mail: n...@sciant.com

[Saba Kauser]

Hi Nikola,
Do you need assistance in setting up connection to informix using ODBC, I can have some expert assist you on server side configuration. Let me know!

Thank you.