Setting Up TCP/IP Support
By default, TCP/IP is supported between PSQL clients and remote database engines or between multiple Workgroup engines. If you have modified the default settings or need to verify that TCP/IP support is available, refer to this section.
*Note: To perform any of the tasks in this section, you must have full administrator-level rights on the machine where the database engine is running, or be a member of the Pervasive_Admin group defined on the machine where the database engine is running.
►
To Enable TCP/IP Support
Complete the following steps to ensure that the database engine can communicate with clients over TCP/IP networks.
1
Access Control Center (PCC) from the operating system Start menu or Apps screen.
2
In the PSQL Explorer, double-click Engines to display a list of the engines registered with PCC.
3
Right-click the target engine and click Properties. Login if prompted.
4
Click Communication Protocols, and the list of Supported protocols displays. If the list of Supported protocols shows the value TCP/IP checked, then TCP/IP is already supported.
5
Click TCP/IP then restart the database engine for the changes to take effect.
*Tip: Remember that you also need to confirm that your client computers or the client software on your other Workgroup computers are configured to use TCP/IP, as well. See Chapter 10, Configuring Network Communications for Clients.
►
To Enable Multihomed TCP/IP Support
Completing the following steps configures your Windows server to use two installed network cards.
1
Access Control Center (PCC) from the operating system Start menu or Apps screen.
2
In the PCC PSQL Explorer, double-click Engines to display the list of registered engines with PCC.
3
Right-click the target engine and click Properties. Login if prompted.
4
Click Communication Protocols and click TCP/IP Multihomed to configure the server engine to listen for client connections on multiple network interfaces.
If you only have one network interface, this setting is ignored.
5
Restart the server engine for the changes to take effect. You do not need to make any changes to client settings.
*Note: If your server computer has two network interfaces, and you set the value of TCP/IP Multihomed to Off, you must edit the setting Listen IP Address and specify the TCP/IP address of the interface on which you want the database engine to listen.

If you do not specify an IP address, the database engine will receive communications only from the first network interface to bind to the operating system. Because this can vary with driver installation, a working system can easily break after receiving driver updates. To avoid this problem, always set the Listen IP Address.