SQL Anywhere Studio Help
Adaptive Server Anywhere Help
Introduction to dialog boxes
The Windows CE Message Types for SQL Remote dialog has the following components:
Your Windows CE device has the following message types This window lists the available message types for your Windows CE device. To select a message type for SQL Remote replication, select a message type from the list and click OK.
The supported message types are FILE, FTP, and SMTP.
The selected message type has the following parameters This window lists the name and value for each parameter for the selected message type.
Name Lists the parameter names for the selected message type.
Value Shows the value for the parameter for the selected message type. You can change the value by clicking in the field and typing a different value.
The following tables list the parameters for each of the supported SQL Remote message types.
Name | Values | Default | Description |
---|---|---|---|
Directory | String |
'' |
Set to the directory under which the messages are stored. The setting is an alternative to the SQLREMOTE environment variable. |
Debug | YES, NO | NO | When set to YES, all file system calls made by the FILE link are displayed. |
Unlink_delay | Integer | Pause for 1 second after first failed attempt, 2 seconds after second failed attempt, etc. | Set to the number of seconds to wait before attempting to delete a file if the previous attempt to delete the file failed. |
For more information about the FILE message system, see The file message system.
Name | Values | Default | Description |
---|---|---|---|
Host | String |
'' |
The host name or IP address of the computer where the messages are stored. |
User | String |
'' |
The user name for accessing the ftp host. |
Password | String |
'' |
The password for accessing the ftp host. |
Root_Directory | String |
'' |
The root directory within the ftp host site under which the messages are stored. |
Port | String |
'' |
The IP port number used for the ftp connection. This is usually not required. |
Debug | YES, NO | NO | This parameter controls whether debugging output appears. |
Active_Mode | YES, NO | NO |
This parameter controls whether the client or the server initiates all data transfer connections.
When this parameter is set to NO, (Passive mode) the client initiates all data transfer connections, in this case the message link. When this parameter is set to YES (Active mode) the server initiates all data connections. If your FTP server is sitting behind an incorrectly configured firewall you may not be able to use the default passive transfer mode. For more information about this parameter, see Troubleshooting ftp problems. |
For more information about the FTP message system, see The ftp message system.
Name | Values | Default | Description |
---|---|---|---|
Local_Host | String |
'' |
The name of the local computer. The local host name is required to initiate a session with any SMTP server. In most network environments, the local host name can be determined automatically and you do not need to supply this value. |
TOP_Supported | YES, NO | YES |
SQL Remote uses a POP3 command called TOP when enumerating incoming messages. The TOP command may not be supported by all POP servers.
Set this value to NO to use the RETR command, which is less efficient but works with all POP servers. |
Smtp_Host | String |
'' |
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 | String |
'' |
The name of the computer on which the POP host is running. It corresponds to the POP3 host field in the SMTP/POP3 login dialog. |
Pop3_Userid | String |
'' |
The POP user ID corresponds to the user ID field in the SMTP/POP3 login dialog. |
Pop3_password | String |
'' |
The POP password corresponds to the password field in the SMTP/POP3 login dialog. |
Debug | YES, NO | NO | This parameter controls whether debugging information appears. When set to YES, SMTP and POP3 commands and responses appear. |
For more information about the SMTP message system, see The SMTP message system.