How to determine port number, service name and server name in Informix

Determine Server Name

• Login to Informix Server
• Type echo $INFORMIXSERVER. Enter.
• From here you can see the your server name.
• e.g ol_myifxdb

Determine Service Name

• Login to Informix server
• Type cd $INFORMIXDIR/etc
• Type cat sqlhosts. Check the line that contain your server  name.
• e.g ol_myifxdb         onsoctcp        192.168.2.200      service_myifxdb
• The line will show you the server name, protocol, server address and service name.

Determine Port Name

• Login to Informix Server
• Type grep <service name> /etc/services
• e.g grep service_myifxdb /etc/services
• The line will show you the service name and port number
• e.g service_myifxdb   60200/tcp

Configure Informix ODBC

These steps are for setting up the Informix odbc in your Windows machine.

• Install Informix SDK Client in your machine.
• Goto C:\Windows\System32\drivers\etc. Open services file. Add service name and port number of the Informix Server that you're connecting to. e.g.

Service Name ad Port Number

• Then goto Control Panel\All Control Panel Items\Administrative Tools. 
• Double click Data Sources (ODBC).
• Under System DSN tab, click Add.
• Select IBM Informix ODBC Driver from the list and click Finish. e.g.

• In General tab, fill in the Data Source Name and Description.
• Fill in the Connection tab as an example as below

• Click Apply & Test Connection