DistributorAddress Property (Replication)

The DistributorAddress property specifies the network address used when connecting to the Distributor. DistributorAddress is specified when the DistributorNetwork property is specified.

Syntax

object.DistributorAddress [= value]

Parameters

  • value
    Network address used when connecting to the Distributor

Applies To

SQL Server Compact 3.5 (SQL Server Compact 3.5) Replication object

Data Type

String

Modifiable

Read/write

Prototype

HRESULT get_DistributorAddress(BSTR *pVal);
HRESULT put_DistributorAddress(BSTR newVal);

Remarks

This is a required property only when DistributorNetwork is set to a value other than DEFAULT_NETWORK.

Specify this property to indicate how the SQL Server Reconciler communicates with the Distributor. For example, if the SQL Server Compact 3.5 Server Agent and the Distributor are located on two different systems and these systems communicate over the Internet, DistributorNetwork could be set to TCP/IP_SOCKETS, and DistributorAddress could be set to a specific IP address. If the DistributorNetwork is TCP/IP_SOCKETS or MULTI_PROTOCOL using TCP/IP, the DistributorNetwork value is in the form: 'IP address,socket', for example, '111.11.11.11,1433'.

If none of the Distributor connection properties are specified, it is assumed the Publisher and Distributor are on the same instance of SQL Server, and the Publisher connection properties are used when connecting to the Distributor. However, if you set any one of the Distributor connection properties, you must set all the required Distributor properties.

See Also

Reference

DistributorNetwork Property (Replication)
Distributor Property (Replication)
Replication Object Properties

Help and Information

Getting Assistance (SQL Server Compact 3.5 Service Pack 1)