Avoiding Unavailable Protocols

It may be possible to improve performance on the initial connection to the database by disabling database communications 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 be seated at the console of the machine running the Workgroup engine. You cannot remotely configure the Workgroup engine.

To Remove Network Protocol Support

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

To run Pervasive PSQL Control Center (PCC), access the Pervasive commands on the Start menu and click Pervasive.SQL <version> Control Center.

In the window, double-click on Engines to display a list of the engines registered with Pervasive PSQL Control Center.

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

In the window to the right, a list of Supported protocols displays. Protocols that are selected on this dialog are considered available for use by the engine.

If the list of Selected protocols includes a value that is not supported on your network or that you do not wish to use, uncheck the value. Repeat for any other protocols you do not wish to use. You must leave at least one protocol in the Selected protocols list.

Click OK.

You need to restart the engine for the changes to take effect.

Remember that you also need to confirm that your client computers are configured to use the protocol remaining in the Supported protocols list. Please refer to Chapter 7, Configuring Network Communications for Clients.