Server Side Setup

Go Up to Automatic Rerouting of Databases

In order to setup simultaneous InterBase servers on a machine follow the instructions specified above. Once these machines are set up, and running, follow the instructions below to setup and use the DB_ROUTE database table in the ADMIN.IB.

The structure of the DB_ROUTE table is as follows:

Column Name	Data type	Length	Description
DB_NAME	CHAR	1024	Complete name of the database to be rerouted, including the path of the database on the server. e.g. Server_Name:DATABASE_DIR\EMPLOYEE.Ib
SERVICE_NAME	CHAR	30	Service name to look up in the services file for the port number to be re-routed to. The look up takes place at the server side, the client is only aware of the port number and not the service name. e.g. ib__a
ACTIVATE_ROUTE	BOOLEAN		Set to true if this re-routing is active, flase it this re-routing is disabled.

The service name that is entered in the set DB_ROUTE table must exist in the services file:

gds_db 3050/tcp #default interbase port number
ib__a 3051/tcp # A’s interbase port number