www.mimer.com/developer

Accessing a Remote Database

---

You can access databases that reside on other nodes in the network environment by editing the REMOTE section in the SQLHOSTS file and adding information about the remote database.

For more information on the SQLHOSTS file, see Editing the SQLHOSTS File.

Access to remote databases is provided by using either DECNET or TCP/IP to establish a client/server connection to the remote machine.

Each entry in the REMOTE section can contain up to five fields, separated by spaces and/or tab characters.

The fields in the REMOTE section specify the following:

Field	Explanation
DATABASE	The DATABASE field specifies the name of the remote database.
NODE	The NODE field specifies the network node name of the remote machine. If you are using the TCP/IP interface, you can specify the IP address here.
PROTOCOL	You can specify DECNET or TCP depending on the type of network protocol to be used to create the client/server connection. The default, specified by '' (two single quote characters), is TCP.
INTERFACE	The INTERFACE field is currently not used. Specify '' (two single quote characters) here.
SERVICE	TCP/IP If using the TCP/IP protocol, enter the TCP/IP port number the database server uses. The default is 1360. DECNET If using DECNET, enter the database name. The server listens to the network object using the same name as the database. (A Mimer SQL 7 database server using DECNET listens to the network object named "MIMER").

Adding a Remote Database

To add a remote database:

1. Open the SQLHOSTS file in a text editor and locate the REMOTE section.
2. Fill in the fields, as specified above, according to your network configuration.

Example of a REMOTE Entry

 REMOTE:
 --
 -- Database           Node               Protocol Interface Service
 -- ------------------ ------------------ -------- --------- -------
    M8ACCESS           STARTREK           TCP      ''        1360   

Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se