SQL Remote User's Guide
SQL Remote Administration
Using message types
The Simple Mail Transfer Protocol (SMTP) is used in Internet e-mail products.
With the SMTP system, SQL Remote sends messages using Internet mail. The messages are encoded to a text format and sent in an e-mail message to the target database. The messages are sent using an SMTP server, and retrieved from a POP server: this is the way that many e-mail programs send and receive messages.
For a list of operating systems for which SMTP is supported, see Supported operating systems.
To use SQL Remote and an SMTP message system, each database participating in the setup requires a SMTP address, and a POP3 user ID and password. These are distinct identifiers: the SMTP address is the destination of each message, and the POP3 user ID and password are the name and password entered by a user when they connect to their mail box.
Separate e-mail account recommendedIt is recommended that a separate POP e-mail account be used for SQL Remote messages. |
If you can not get the SMTP Link to work try connecting to the SMTP/POP3 server from the same machine on which the Message Agent is running using the same account and password. Use an Internet e-mail program that supports SMTP/POP3 and make sure to disable the program once the SMTP message link is working.
Before the Message Agent connects to the message system to send or receive messages, the user must either have a set of control parameters already set on their machine, or must fill in a window with the needed information. This information is needed only on the first connection. It is saved and used as the default entries on subsequent connects.
The SMTP message system uses the following control parameters:
local_host This is the name of the local computer. It is useful on machines where SQL Remote is unable to determine the local host name. The local host name is needed to initiate a session with any SMTP server. In most network environments, the local host name can be determined automatically and this entry is not needed.
TOP_supported SQL Remote uses a POP3 command called TOP when enumerating incoming messages. The TOP command may not be supported by all POP servers. Setting this entry to NO will use the RETR command, which is less efficient but will work with all POP servers. The default is YES.
smtp_authenticate Determines whether the SMTP link authenticates the user. The default value is YES. Set to NO for no SMTP authentication to be carried out.
smtp_userid The user ID for SMTP authentication. By default this parameter takes the same value as the pop3_userid parameter. The smtp_userid only needs to be set if the user ID is different to that on the POP server.
smtp_password The password for SMTP authentication. By default this parameter takes the same value as the pop3_password parameter. The smtp_password only needs to be set if the user ID is different to that on the POP server.
smtp_host This is the name of the computer on which the SMTP server is running. It corresponds to the SMTP host field in the SMTP/POP3 login dialog.
pop3_host This is the name of the computer on which the POP host is running. It is commonly the same as the SMTP host. It corresponds to the POP3 host field in the SMTP/POP3 login dialog.
pop3_userid This is used to retrieve mail. The POP user ID corresponds to the user ID field in the SMTP/POP3 login dialog. You must obtain a user ID from your POP host administrator.
pop3_password This is used to retrieve mail. It corresponds to the password field in the SMTP/POP3 login dialog. If all of these five fields are set, the login dialog is not displayed.
Debug When set to YES, displays all SMTP and POP3 commands and responses. This is useful for troubleshooting SMTP/POP support problems. Default is NO.