host   The host name of the computer where the FTP server is running. This parameter can be a host name (such as FTP.ianywhere.com) or an IP address (such as 192.138.151.66).

user   The user name for accessing the FTP host.

password   The password for accessing the FTP host.

root_directory   The root directory within the FTP host site that the messages are stored under.

port   The IP port number used for the FTP connection. This parameter is usually not required.

debug   This parameter is set either to YES or NO. The default is NO. When set to YES, debugging output is displayed in the output log.

active_mode   This parameter controls how SQL Remote establishes the server/client connection. This parameter is set either to YES or NO. The default is NO (passive mode). Passive mode is the preferred transfer mode and the default for the FTP message link. In passive mode, all data transfer connections are initiated by the client, in this case, the message link. In active mode, the FTP server initiates all data connections.

reconnect_retries   The number of times the link should try to open a socket with the server before failing. The default value is 4. When you set this parameter, only reconnections are affected. The initial connection made by the FTP link is not affected.

reconnect_pause   The time in seconds to pause between each connection attempt. The default setting is 30 seconds. When you set this parameter, only reconnections are affected. The initial connection made by the FTP link is not affected.

suppress_dialogs   This parameter is set to ON or OFF. If it is set to ON, the Connect window does not appear after failed attempts to connect to the FTP server. Instead, an error is generated.

invalid_extensions   A comma-separated list of file extensions that you do not want dbremote to use when generating files in the messaging system.

encode_dll   If you have implemented a custom encoding scheme, you must set this parameter to the full path of the custom encoding DLL that you created.

max_retries   By default, when SQL Remote is running in continuous mode and an error occurs when accessing the message system, it shuts down after the send and/or receive phases. Use this parameter to specify the number of times you want SQL Remote to retry the send and/or receive phases before it shuts down.

pause_after_failure   This parameter applies when the max_retries parameter is specified to a value other than zero and SQL Remote is running in continuous mode. When an error occurs in the message system, this parameter defines the number of seconds SQL Remote waits between retrying the send and/or receive phases.