Connecting to Informix from Net5.IBM.Data.Db2
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_drdaI 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
One more data, the file /etc/services also defines: informix 9088/tcp # Informix server informix_drda 9094/tcp # Informix server drda #Informix #Support #SupportMigration