Configure the Informix native client

Perform the following steps on Windows:

1. Expand the Start menu.

2. Expand the Programs menu.

3. Expand the INFORMIX-Connect folder.

4. Launch Informix Setnet32.

5. Click the Environment tab.

6. Pass the full path to the Informix client installation to the INFORMIXDIR variable.

7. Pass the name of the Informix DBMS server (not physical machine) to INFORMIXSERVER.

8. Click the Server Information tab.

9. Pass the name of the Informix DBMS server (not physical machine) to Informix Server.

10. Pass the hostname of the physical Informix server to HostName.

11. Pass the Informix protocol (olsoctcp, onsoctcp) to Protocolname.

12. Pass the service name from /etc/services or \etc\servicse to Service Name.

13. Click the Host Information tab.

14. Pass the hostname of the physical Informix server to Current Host.

15. Pass the Informix username to User Name.

16. Select your password option.

17. Provide a password, as required.

18. Close Informix Setnet32.

19. Expand the Start menu.

20. Expand the Programs menu.

21. Expand the INFORMIX-Connect folder.

22. Launch ILogin Demo.

23. Expand the File menu.

24. Select Run.

25. Fill in the values.

26. Click OK.

Perform the following steps on Unix:

1. Login to the Unix client.

2. su to the Informix user.

3. cd into the root of the Informix client installation.

4. Run the Informix user's .profile.

5. cd into the /etc sub-directory of the Informix installation.

6. vi sqlhosts.

7. Create one line that passes the: Informix DBMS server name, Informix protocol, hostname of Informix server, Informix service from services file.

8. Exit sqlhosts.

Here is a sample Unix $INFORMIXDIR/etc/sqlhosts file:

      ol_saturn olsoctcp saturn.testserver.com inf9srv

Note: Don't know what values to pass to Informix SetNet32 or $INFORMIXDIR/etc/sqlhosts? If your Informix server is running on Unix, you will find the appropriate values in the server's /etc/services, Informix .profile, and $INFORMIXDIR/etc/sqlhosts files. If your Informix server is running on Windows, you will find the appropriate values in the server's C:\Windows \System32\Drivers\etc\services file, the Server Instance Manager (Start Menu), and the $INFORMIXDIR\etc\onconfig file.