Setting Up TCP/IP Support

By default, TCP/IP is supported between Pervasive PSQL clients and remote database 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.

Enabling TCP/IP Support

Complete the following steps to ensure that the database engine can communicate with clients over TCP/IP networks.

Remember that you also need to confirm that your client computers are configured to use TCP/IP, as well. See Chapter 18, Configuring Network Communications for Clients.

Start Pervasive PSQL Control Center (PCC) from the Pervasive program on the Start menu.

In the PCC Pervasive PSQL Explorer, double-click Engines to display a list of the engines registered with PCC.

Right-click on the icon representing your target engine then click Properties. Login if prompted. Click on Communication Protocols.

In the window to the right, a list of Supported protocols displays. If the list of supported protocols shows the option TCP/IP as checked, then TCP/IP is already supported. Skip the remaining steps in this task.

If the list of selected protocols does not show the option TCP/IP as checked, complete the remaining steps.

Click the option for TCP/IP in the list of supported protocols.

Click OK.

Click Yes to restart the database engine.

Enabling Multihomed TCP/IP Support

Follow this procedure if your Windows server computer has two network cards installed.

Start Pervasive PSQL Control Center (PCC) from the Pervasive program on the Start menu.

In the PCC Pervasive PSQL Explorer, double-click Engines to display a list of the engines registered with PCC.

If the engine you want to configure is not listed, right-click on Engines and click New Server. Provide a server name or IP address then click Finish.

Right-click on the icon representing your target engine then click Properties. Login if prompted.

Click on Communication Protocols.

In the window to the right, you can see the current setting for TCP/IP Multihomed.

If you want the server engine to listen for client connections on both network cards, click the option for TCP/IP Multihomed.

If you only have one network card, this setting is ignored.

If you want the server engine to listen on only one card, deselect (uncheck) the option.

Click OK.

Click Yes to restart the database engine.

You do not need to make any changes to client settings.

Note
If your server computer has two network cards, and you set the value of TCP/IP Multihomedto Off, you must edit the setting Listen IP Address and specify the TCP/IP address of the card on which you want the database engine to listen. If you do not specify an IP address, the database engine will not receive communications from either network card.