Using a Network Connection

Figure 18 shows a configuration in which the client application resides on host river and the database server resides on host valley.

Figure 18. A Network Configuration

An entry for the valley_ds database server is in the sqlhosts files on both computers. Each entry in the sqlhosts file on the computer where the database server resides has a corresponding entry on the computer where the client application resides.

Both computers are on the same TCP/IP network, but the host river uses sockets for its network programming interface, while the host valley uses TLI for its network programming interface. The nettype field must reflect the type of network programming interface used by the computer on which sqlhosts resides. In this example, the nettype field for the valley_ds database server on host river is onsoctcp, and the nettype field for the valley_ds database server on host valley is ontlitcp.

The sqlhosts File Entry for IPX/SPX

IPX/SPX software frequently provides TLI. If the configuration in Figure 18 uses IPX/SPX instead of TCP/IP, the entry in the sqlhosts file on both computers is as follows.

In this case, the hostname field contains the name of the NetWare file server. The servicename field contains a name that is unique on the IPX/SPX network and is the same as the dbservername.