Avoiding Unavailable Protocols

It may be possible to improve performance on the initial connection to the database by disabling database communication support for any protocols that are not available on your network or that you do not wish to use.

Note
In order 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 Remove Support for a Specific Network Protocol

Remember that you also need to confirm that your client computers are configured to use same protocol(s) as the database engine. See Chapter 18, Configuring Network Communications for Clients.

Note
This task does not affect your operating system configuration in any way. This this prevents only the database communication system from attempting to communication on unavailable or undesired protocols.

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. Protocols for which the option is selected (check marked) are considered available for use by the database engine.

If the list of selected protocols includes any protocols that are not supported on your network or that you do not wish to use, uncheck the option for that protocol.

You must leave at least one protocol selected in the Selected protocols list.

Click OK.

Click Yes to restart the database engine.