1. First, make the following assumptions about the environment for the following operations:
1. Server Side
Server machine name: scoserverip address: 10.0.0.1
Database Name: informixserverservicename: sqlexec
Port: 5000/tcp
Database username: informix
Database User Password: informix
2. Client
Windowsxp + informixconnect2.8
Ii. how to obtain the above parameters
1. Run the hostname command to view the server machine name.
2. IP Address: You can use ifconfig-a to view the IP address.
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: Find the servicename and find it in the/etc/services file.
3. Client settings
1. We recommend that you configure the hosts and services files on the client to include the server content. The procedure is as follows:
The Windows XP hosts and services files are stored in the % systemroot %/system32/drivers/etc directory.
Add a line after hosts:
10.0.0.1 scoserver
Add a line after services
Sqlexec 5000/tcp
2. Run DBping to test the connectivity with the server.
Use ping to test physical connection. Remember to enter the host name directly in the hostname field without IP addresses.
Because you have configured the hosts file)
Then use iconnect for logical ping
Enter the above information based on your actual situation), and then select sysmaster for the database.
3. Create an odbc connection and test again. The problem should not be big. The parameters to be filled in are available in the iconnect test.