DistributorAddress Property (Replication)

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

Applies To
SQLDistribution Object SQLMerge Object

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

Remarks

This is a required property only when DistributorNetwork 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 was to be accessed over the Internet,  DistributorNetwork could be set to TCPIP_SOCKETS and DistributorAddress could be set to an specific IP address.

If the DistributorNetwork is TCP/IP_SOCKETS or MULTI_PROTOCOL using TCP/IP, then 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 the Publisher and Distributor are the same Microsoft® SQL Server™ installation 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
Distributor Property DistributorNetwork Property

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.