FTPPassword Property (Replication ActiveX)

The FTPPassword property specifies the password of the File Transfer Protocol (FTP) site where the publication snapshot files are stored.

Sicherheitshinweis:
When possible, prompt users to enter their credentials at run time. Avoid hard-coding or storing credentials in a file. If credentials must be persisted between runs, encrypt them using the Win32 CryptoAPI functions. For more information, see this Microsoft Web site.

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

Syntax

object.FTPPassword [= value]

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

Applies To

SQLDistribution Object (Replication ActiveX)

SQLMerge Object (Replication ActiveX)

Hinweise

The default is no password. Typically, an e-mail address of the form user@company.com is used for FTP passwords.

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 Microsoft SQL Server 7.0 Subscriber.

Data Type

String

Modifiable

Read/write

Prototype C/C++

HRESULT get_FTPPassword(BSTR *pVal);
HRESULT put_FTPPassword(BSTR newVal);

Siehe auch

Verweis

FTPAddress Property (Replication ActiveX)
FTPLogin Property (Replication ActiveX)
FTPPort Property (Replication ActiveX)

Hilfe und Informationen

Informationsquellen für SQL Server 2005