Sybase SQL Remote DC38133-01-0902-01 User Manual
Chapter 10. SQL Remote Administration
The parameters for each message link go in a key under the SQL Remote
key, with the name of the message link (4,
key, with the name of the message link (4,
smtp, and so on).
♦
NetWare
You should create a file named
dbremote.ini in the
sys:\system directory to hold the FILE system directory setting. This file
is not a Windows-format INI file: it must consist of a single line, holding
only the directory name.
is not a Windows-format INI file: it must consist of a single line, holding
only the directory name.
For example, if the directory is
user:\dbr43, then the dbremote.ini file
would contain the following:
user:
\
dbr43
♦
UNIX
The FILE system directory setting is held in the SQLREMOTE
environment variable.
The
sqlremote environment variable holds a path that can be used as an
alternative to one of the control parameters for the file sharing system.
The parameters available for each message system are discussed in the
following sections. Each section describes a single message system.
following sections. Each section describes a single message system.
When the Message Agent loads a message link, the link uses the settings of
the current publisher or, if a setting is not specified, of groups to which the
publisher belongs. On Windows, the first time a version of the Message
Agent is run that supports storing the message link parameters in the
database, it copies the link options from the registry to the database.
the current publisher or, if a setting is not specified, of groups to which the
publisher belongs. On Windows, the first time a version of the Message
Agent is run that supports storing the message link parameters in the
database, it copies the link options from the registry to the database.
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.
by using the file message system.
Addresses in the file
message system
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.
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.
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
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.
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.
215