Windows Mobile Message Types for SQL Remote window

This window has the following components:

Your Windows Mobile device has the following message types   This window lists the available message types for your Windows Mobile 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 the field and typing a different value.

The following tables list the parameters for each supported SQL Remote message type.

FILE message control parameters
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. See 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, and so on. Set to the number of seconds to wait before attempting to delete a file if the previous attempt to delete the file failed.

See The FILE message system.

FTP message control parameters
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 database 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 database 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.

See Troubleshooting FTP problems.

See The FTP message system.

SMTP message control parameters
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 window.
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 window.
Pop3_Userid String
''
The POP user ID corresponds to the user ID field in the SMTP/POP3 login window.
Pop3_password String
''
The POP password corresponds to the password field in the SMTP/POP3 login window.
Debug YES, NO NO This parameter controls whether debugging information appears. When set to YES, SMTP and POP3 commands and responses appear.

See The SMTP message system.

See also