Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Expand all | Collapse all

Connecting to Informix from Net5.IBM.Data.Db2

  • 1.  Connecting to Informix from Net5.IBM.Data.Db2

    Posted Fri August 27, 2021 05:59 PM

    I can't get working the db2 provider with Informix.

    I keep getting this error:

    ERROR [08001] [IBM] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "172.16.0.205". Communication function detecting the error: "connect". Protocol specific error code(s): "10060", "*", "*". SQLSTATE=08001

    I already checked windows firewall settings as said at https://www.ibm.com/support/pages/sql30081n-communication-error-has-been-detected-errors-when-connecting-controller-application-server-db2-database-server

    Program used (.NET5):

    string cstr = "Server=172.16.0.205:9094;userid=informix;Password=xxxx;database=testcore;"

    conn = new DB2Connection(cstr);

    conn.Open();

    Informix Server on Linux Version: 12.10

    /opt/informix/etc/onconfig.std defines the alias:

    DBSERVERNAME informixfullgx

    DBSERVERALIASES informixfullgx_drda

    /opt/informix/etc/sqlhosts has these lines:

    #dbservername nettype hostname servicename options

    informixfullgx onsoctcp 172.16.0.205 informix

    informixfullgx_drda drsoctcp 172.16.0.205 informix_drda

    I also tried to connect using Informix.Net.Core (+ CSDK) from the same machine and it works fine, it connects ok with this code:

    var cstr = "Server=informixfullgx;User ID=informix;Password=xxxx;database=testcore;Service=9088";

    IfxConnection iconn= new IfxConnection(cstr);

    iconn.Open();

    Why IBM.Data.Db2 doesn't work?

    Any help would be appreciated.






    #Informix
    #Support
    #SupportMigration


  • 2.  RE: Connecting to Informix from Net5.IBM.Data.Db2

    Posted Fri August 27, 2021 06:01 PM

    One more data, the file /etc/services also defines:

    informix 9088/tcp # Informix server

    informix_drda 9094/tcp # Informix server drda






    #Informix
    #Support
    #SupportMigration