Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Informix
Expertise: Beginner
Aug 14, 2000



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Using Ports with Informix

From a Windows system I am trying to connect to an Informix database running on a Sun Solarix box, which was just moved behind a firewall. The Windows machine is running Access and using ODBC. It appears that the client chooses a random port to connect to the server based on the firewall blocks. Can the database be configured to use set ports rather than what appears to be random?

Informix uses dedicated ports to communicate. In recent systems it is often 1526, although this can be configured. On Windows systems you use the setnet32 program to set up the connection parameters to each server. On the server, this is done with the $INFORMIXDIR/etc/sqlhosts file in conjunction with the /etc/hosts and /etc/services file. Client and servers must be configured the same. The ODBC layer runs on top of this Informix native connection.

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date