FTPAddress Property (Replication ActiveX)

The FTPAddress property specifies the IP address of the File Transfer Protocol (FTP) site where publication snapshot files are stored.

Important   Support has been dropped for creating subscriptions to Subscribers running Microsoft SQL Server version 7.0 that are initialized using FTP.

Syntax

object.FTPAddress [= value]

Hinweise

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

Applies To

SQLDistribution Object (Replication ActiveX)

SQLMerge Object (Replication ActiveX)

Hinweise

FTPAddress is an optional property.

If specified, the FTPLogin Property (Replication ActiveX), FTPPassword Property (Replication ActiveX), and FTPPort Property (Replication ActiveX) 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 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 or later publications unless the Subscriber is a SQL Server version 7.0 Subscriber.

Hinweis:
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);

Siehe auch

Verweis

Distributor Property (Replication ActiveX)
DistributorAddress Property (Replication ActiveX)

Hilfe und Informationen

Informationsquellen für SQL Server 2005