Concurrent Local and Remote Applications

The Server engine allows both remote client requests as well as communications from applications running on the same computer as the server. This section explains what server Configuration settings are used to enable remote and local access.

Note
To perform these steps, 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 database connections from both remote and local applications

You must be sitting at the Windows server computer where the database server runs. Access the Pervasive commands on the Start menu and click Pervasive PSQL Control Center.

In the Pervasive PSQL Explorer 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 Access.

In the right-hand window pane, ensure that Accept Remote Requests is enabled. If you wish to prevent the server from accepting client connections from other computers, uncheck the value. Click OK.

In the Pervasive PSQL Explorer window, expand Local Client.

Right-click on MicroKernel Router and select Properties. Login if prompted.

Click Access. In the window to the right, ensure the following settings are properly set:

Use Local MicroKernel Engine. Set the value to On.

Use Remote MicroKernel Engine. If you want to be able to access databases on other computers, enable this setting. If you plan to access data on this computer only, disable this setting.

Click OK.

You must restart the server engine for the changes to take effect.