Contents Index Setting message type control parameters The ftp message system

SQL Remote User's Guide
  SQL Remote Administration
    Using message types

The file message system


SQL Remote can be used even if you do not have a message system in place, by using the file message system.

Addresses in the file message system 

The file message system is a simple file-sharing system. A file address for a remote user is a subdirectory into which all their messages are written. To retrieve messages from their "inbox", an application reads the messages from the directory containing the user's files. Return messages are sent to the address (written to the directory) of the consolidated database.

When running as an NT service make sure that the account under which the Message Agent is running has permissions to read and write all necessary directories. This is often a problem when accessing network drives.

Root directory for addresses 

The file system addresses are typically subdirectories of a shared directory that is available to all SQL Remote users, whether by modem or on a local area network. Each user should have a registry entry, initialization file entry, or SQLREMOTE environment variable pointing to the shared directory.

You can also use the file system to put the messages in directories on the consolidated and remote machines. A simple file transfer mechanism can then be used to exchange the files periodically to effect replication.

FILE message control parameters 

The FILE message system uses the following control parameters:

On NetWare, you should create a file named dbremote.ini in the sys:\system directory to hold the directory setting.


Contents Index Setting message type control parameters The ftp message system