FTPAddress Property

Replication Programming

Replication Programming

FTPAddress Property

The FTPAddress property specifies the IP address of the FTP site where publication snapshot files are stored.

Applies To

SQLDistribution Object

SQLMerge Object

Syntax

object.FTPAddress [= value]

Part Description
object Expression that evaluates to an object in the Applies To list.
value Network address of the FTP site.
Remarks

FTPAddress is an optional property.

If specified, the FTPLogin, FTPPassword, and FTPPort properties are also used.

This option is useful when configuring the control to connect to a Distributor over the Internet, where the Distributor working directory is not directly accessible. Setting this property forces the control to download all publication snapshot files using File Transfer Protocol (FTP) before applying them at the Subscriber.

These properties should not be required when you dynamically determine the FTP login properties by querying the publication. Provided for backward compatibility only: these properties will not be effective when used against Microsoft® SQL Server™ 2000 publications unless the Subscriber is a Microsoft SQL Server version 7.0 Subscriber.

Note  The publication must be enabled for the Internet.

Data Type

String

Modifiable

Read/write

Prototype C/C++

HRESULT get_FTPAddress(BSTR *pVal);

HRESULT put_FTPAddress(BSTR newVal);

See Also

Distributor Property

DistributorAddress Property

Implementing Replication Over the Internet