Client Side Settings for Automatic Rerouting of Databases
Go Up to Automatic Rerouting of Databases
No client side settings are required. In order to access the database database_name.ib located in the directory database_dir. On a remote machine remote_host accepting connections on a default port number. The database name specified in the client API or any InterBase driver would be REMOTE_HOST:DATABASE_DIR\DATABASE_NAME.IB.
In order to setup the database server AGNI so that it can re-route in coming connections, for the database c:\smistry\employee.ib to an older server running on port number specified by the service ib__a. The ADMIN.IB database on server AGNI will need the following row of information in DB_ROUTE table.
| DB_ROUTE Column Name | Value |
|---|---|
|
DB_NAME |
Server_Name:DATABASE_DIR/EMPLOYEE.IB |
|
SERVICE_NAME |
ib__a |
|
ACTIVATE_ROUTE |
TRUE |
Since the DB_ROUTE is a regular InterBase table in the ADMIN.IB database, you can use regular SQL to enter, modify or remove database re-routing from information.