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