I have installed Informix 14.10 on Redhat 8 Linux.
The IP Address of the server is 192.168.183.129
I am able to ping it from Windows successfully
The hostname is localhost.localdomain
The DBSERVERNAME ol_informix1410
The $INFORMIXDIR/etc/sqlhosts is as follows:
#dbserver net_Type Host_Name Service_Name
ol_informix1410 onsoctcp localhost.localdomain ol_informix1410
dr_informix1410 drsoctcp localhost.localdomain dr_informix1410
lo_informix1410 onsoctcp 127.0.0.1 lo_informix1410
ol_informix1410 onsoctcp 192.168.183.129 ol_informix1410
The /etc/hosts contains:
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.183.129 localhost localhost.localdomain localhost4 localhost4.localdomain4
The services on linux have the following ports:
ol_informix1410 10070/tcp
ol_informix1410_json 27017/tcp
when running the dbaccess on Linux
DBACCESS: Query-language Connection Database Table Session Exit
Retrieve information about the current DB-Access session.
----------- superstore_demo@ol_informix1410 ------ Press CTRL-W for Help ------
Server
ol_informix1410
Dynamic Server
Connected to host192.168.183.129
Multi-threaded
Server Capabilities
NLS
Distributed
XA
NLS Capabilities and Attributes
en_US.819 Collating Sequence
en_US.819 CType
I Installed the IBM INFORMIX ODBC DRIVER (64-bit), version 4.50.00.18347 (file:ICLIT09B.DLL) date 23/10/2021 on Microsoft windows 10.
Then added a new system DSN as follows: ODBC DSN
When I press Apply & Test Connection button, I get the following error: **Test connection was not successful. [Informix][Informix ODBC Driver][Informix] System error occurred in network function.**
Any suggestion?
In my case, I had to open the port 10070/tcp in the Redhat firewall. After restarting the firewall, ODBC connected successfully.
Thank you @jsagrera and @JeroniChamorro for your suggestions.
