Server Side Setup

From InterBase
Jump to: navigation, search

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