Local and remote databases
It is always possible to use additional remote HyperLab databases on other computers in your local network – provided the remote database server allows incoming connections and you have the proper password assigned to those databases.
Advantages of remote databases
Remote databases may be shared between working group members
Database files and the MSDE database server itself may be hosted on a powerful server computer, where regular backup is performed, so the chance for data loss is minimized.
Drawbacks of remote databases
HyperLab disallows specific operations (e.g. database creation) on remote databases. In order to create a HyperLab database, you should run database creation utility on the destination machine.
The networked database connection may be slower than accessing local databases.
Installation on the remote computer
Install all HyperLab components, including the Main Module and the MSDE database server.
Create a new database from the Main Module: click on “Local Database Server” node, then select task “Create database” from the right and follow the instructions.
Make sure if the database server accepts incoming connections: click on “HyperLab databases” node, then select task “Manage database server” from the right. The management window appears now. Make sure that “TCP/IP” protocol is enabled. See “
Configuring remote access“ for further details.
Installation on the local computer
Install all HyperLab components, including the Main Module and the MSDE database server.
Create a local database from the Main Module: click on “Local Database Server” node, then select task “Create database” from the right.
Register the new local database in Main Module: click on “HyperLab databases” node, then select task “Register a local database” from the right.
Register the remote database on the remote computer: click on “HyperLab databases” node, then select task “Register a remote database” from the right and follow the instructions. Specify the remote computer name as the database server host name.
Start using your newly registered local and remote databases. Please note that the user name and password is tied to the database server – thus it is possible that you should specify different passwords for the local and the remote databases.
