The DistributorAddress property specifies the network address used when connecting to the Distributor when the DistributorNetwork property is specified.
SQLDistribution Object | SQLMerge Object |
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 |
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.
String
Read/write
HRESULT get_DistributorAddress(BSTR *pVal);
HRESULT put_DistributorAddress(BSTR newVal);
Distributor Property | DistributorNetwork Property |