Jaa


DistributorAddress Property (Replication ActiveX)

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

Syntax

object.DistributorAddress [= value]
Part Description

object

Expression that evaluates to an object in the Applies To list.

value

Network address used when connecting to the Distributor.

Applies To

SQLDistribution Object (Replication ActiveX)

SQLMerge Object (Replication ActiveX)

Remarks

This is a required property only when DistributorNetwork Property (Replication ActiveX) is set to a value other than DEFAULT_NETWORK.

This property is useful when configuring the control to connect to the Distributor without having to use SQL Server Client Network Utility.

For example, if the Distributor is accessed over the Internet, DistributorNetwork Property (Replication ActiveX) can be set to TCPIP_SOCKETS and DistributorAddress can be set to a specific IP address.

If the DistributorNetwork Property (Replication ActiveX) is TCP/IP_SOCKETS or MULTI_PROTOCOL using TCP/IP, the value is in the form of 'IP address,socket' (i.e. '111.11.11.11,1433')

If the Distributor connection properties are not specified, it is assumed that the Publisher and Distributor are the same instance of Microsoft SQL Server and the Publisher connection properties will be used when connecting to the Distributor.

Data Type

String

Modifiable

Read/write

Prototype C/C++

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

See Also

Reference

Distributor Property (Replication ActiveX)

Help and Information

Getting SQL Server 2005 Assistance