sp_hook_dbmlsync_set_ml_connect

sp_hook_dbmlsync_set_ml_connect_info

Use this stored procedure to set the network protocol and network protocol options.

Name	Value	Description
publication_n (in)	publication	The publications being synchronized, where n is an integer. There is one publication_n entry for each publication being uploaded. The numbering of n starts at zero.
MobiLink user (in)	MobiLink user name	The MobiLink user for which you are synchronizing.
script version (in)	script version name	The MobiLink script version to be used for the synchronization.
connection type (in/out)	tcpip, tls, http, or https	The network protocol that is used to connect to the MobiLink server.
connection address (in/out)	protocol options	The communication address that is used to connect to the MobiLink server. See MobiLink client network protocol option summary.

Remarks

You can use this hook to set the network protocol and network protocol options.

The protocol and options can also be set in the sp_hook_dbmlsync_set_extended_options, a hook that is called at the beginning of a synchronization. sp_hook_dbmlsync_set_ml_connect_info is called immediately before dbmlsync attempts to connect to the MobiLink server.

This hook is useful when you want to set options in a hook, but want to do so later in the synchronization process than the sp_hook_dbmlsync_set_extended_options. For example, if the options should be set based on the availability of signal strength of the network that is being used.

Example

CREATE PROCEDURE sp_hook_dbmlsync_set_ml_connect_info()
begin
    UPDATE #hook_dict 
    SET VALUE = 'tcpip'
      WHERE name = 'connection type';

    UPDATE #hook_dict 
    SET VALUE = 'host=localhost'
      WHERE name = 'connection address';
end

Send feedback about this page via email or DocCommentXchange