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.
*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 configure database connections from both remote and local applications
*Tip: When changing the Server engine settings, you must be at the Windows server computer where the database server runs.
1
Access Control Center (PCC) from the operating system Start menu or Apps screen.
2
In the PSQL Explorer, expand Engines to display the engines registered with PSQL Control Center.
3
Right-click the target engine and click Properties. Login if prompted.
4
Click Access. In the right-hand pane, select the Accept Remote Requests check box.
If you wish to prevent the server from accepting client connections from other computers, clear the check box.
5
Click OK.
This configures the server to accept remote requests.
6
In the PSQL Explorer, expand Local Client.
7
Right-click MicroKernel Router and click Properties. Login if prompted.
8
Click Access. In the right-hand pane, select the following check boxes:
•
Use Local MicroKernel Engine. Select this check box to configure the local engine for local file access.
•
Use Remote MicroKernel Engine. Select this check box to access databases on other computers.
If you plan to only access data on this computer, clear this check box.
9
Click OK.
This configures the server to accept local requests.
10
Restart the server engine to implement the changes.
Using the Server and Workgroup Engines Concurrently
The Workgroup engine can be configured to access files on a remote file server through a mapped drive on a Windows server.
The client software installed with your Workgroup engine can be used to connect to other server engines on a remote machine.
If you want to use your local engine for local file access and a remote server for access to files being serviced by the remote PSQL server, you must change the settings in your MicroKernel Router. Use the PSQL Control Center to change MicroKernel Router settings.
►
To configure local and remote access for the MicroKernel Router
1
Access Control Center (PCC) from the operating system Start menu or Apps screen.
2
In the PSQL Explorer window, expand Local Client.
3
Right-click MicroKernel Router and click Properties. Login if prompted.
4
Click Access. In the right-hand pane, select the following check boxes:
•
Use Local MicroKernel Engine. Select this check box to configure the local engine for local file access.
•
Use Remote MicroKernel Engine. Select this check box to configure the remote server for access to files being serviced by the remote PSQL server.
5
Click OK.
*Note: See Advanced Operations Guide for more information on changing settings using the PSQL Control Center.