Win XP under Informix Connect configuration method

First, the following operating environment to make the following assumptions

1. Server-side

Server machine Name: Scoserverip Address: 10.0.0.1

Database name: informixserverservicename:sqlexec

Port number: 5000/tcp

Database user name: Informix

Database user password: Informix

2. Client

windowsxp+informixconnect2.8

Second, how to get the above parameters

1. Server machine name, that is hostname, can be viewed with hostname command.

2.ip Address: You can use IFCONFIG-A to see

3. Database name: You can view the $informixserver/etc/sqlhosts file. The first column is the database name

4.servicename: You can view the $informixserver/etc/sqlhosts file. The last column is ServiceName.

5. Port number: After the ServiceName, in the/etc/services file find the ServiceName can be found

Third, the client's settings

1. It is recommended that the client configure hosts,services these two files to contain the contents of the server. The following are specific practices:

WINDOWXP hosts, and services two files are placed under the%SYSTEMROOT%/SYSTEM32/DRIVERS/ETC directory.

Add a row after the hosts:

10.0.0.1 Scoserver

Add a row after services

SqlExec 5000/tcp

2. Run dbping test and server connectivity.

Ping to test the physical connectivity first, remember to enter the machine name directly in the hostname place, without the IP address.

(because you already have the Hosts file)

And then use iconnect to ping it logically.

According to the above information to fill out (of course, according to your actual situation to fill in), and then the database select Sysmaster, should be successful.

3. Finally build an ODBC connection, and then test. The problem should be small, the parameters to be filled out in the iconnect test.