Export (0) Print
Expand All
Expand Minimize

DistributorAddress Property (Replication)

SQL Server 2000

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.

Applies To

SQL Server CE Replication object

Syntax
object.DistributorAddress [= value]
Part Description
object SQL Server CE Replication object
value Network address used when connecting to the Distributor
Data Type

string

Modifiable

Read/write

Prototype eVC++
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 CE 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 of the Distributor connection properties, you must set all of the required Distributor properties.

See Also
DistributorNetwork Property (Replication)

Distributor Property (Replication)

Replication Object Properties

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft