SqlCeReplication.PublisherAddress Property

Specifies the network address used when connecting to the Publisher.

Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)

Syntax

'Declaration
Public Property PublisherAddress As String
'Usage
Dim instance As SqlCeReplication
Dim value As String

value = instance.PublisherAddress

instance.PublisherAddress = value

public string PublisherAddress { get; set; }

public:
property String^ PublisherAddress {
    String^ get ();
    void set (String^ value);
}

/** @property */
public String get_PublisherAddress ()

/** @property */
public void set_PublisherAddress (String value)

public function get PublisherAddress () : String

public function set PublisherAddress (value : String)

Not applicable.

Property Value

The network address used when connecting to the Publisher.

Remarks

The PublisherAddress property is required when PublisherNetwork is set to a value other than DefaultNetwork.

Specify this property to indicate how the SQL Server Replication Provider communicates with the Publisher. For example, if the SQL Server Compact Edition Replication Agent and the Publisher are located on two different systems and these two systems communicate over the Internet, PublisherNetwork could be set to TcpIpSockets, and PublisherAddress could be set to a specific IP address.

If the PublisherNetwork value is set to TcpIpSockets or MultiProtocol, then the PublisherAddress value is in the form of 'IP address,port number' (for example, '111.11.11.11,1433').

Example

The following example sets the PublisherAddress property of the SqlCeReplication object.

Dim repl As SqlCeReplication = Nothing

Try
    ' Instantiate and configure SqlCeReplication object
    '
    repl = New SqlCeReplication()
    repl.InternetUrl = "https://www.adventure-works.com/sqlmobile/sqlcesa30.dll"
    repl.InternetLogin = "MyInternetLogin"
    repl.InternetPassword = "<password>"
    repl.Publisher = "MyPublisher"
    repl.PublisherDatabase = "MyPublisherDatabase"
    repl.PublisherLogin = "MyPublisherLogin"
    repl.PublisherPassword = "<password>"
    repl.Publication = "MyPublication"
    repl.Subscriber = "MySubscriber"
    repl.SubscriberConnectionString = "Data Source=MyDatabase.sdf"

    ' Create the local SQL Mobile Database subscription
    '
    repl.AddSubscription(AddOption.CreateDatabase)

    ' Synchronize to the SQL Server to populate the Subscription 
    '
    repl.Synchronize()
Catch
    ' Handle errors here
    '
Finally
    ' Dispose the repl object
    '
    repl.Dispose()
End Try

SqlCeReplication repl = null;

try
{
    // Instantiate and configure SqlCeReplication object
    //
    repl = new SqlCeReplication();
    repl.InternetUrl = "https://www.adventure-works.com/sqlmobile/sqlcesa30.dll";
    repl.InternetLogin = "MyInternetLogin";
    repl.InternetPassword = "<password>";
    repl.Publisher = "MyPublisher";
    repl.PublisherDatabase = "MyPublisherDatabase";
    repl.PublisherLogin = "MyPublisherLogin";
    repl.PublisherPassword = "<password>";
    repl.Publication = "MyPublication";
    repl.Subscriber = "MySubscriber";
    repl.SubscriberConnectionString = "Data Source=MyDatabase.sdf";

    // Create a local SQL Mobile Database subscription
    //
    repl.AddSubscription(AddOption.CreateDatabase);

    // Synchronize to the SQL Server database
    //
    repl.Synchronize();
}
catch (SqlCeException)
{
    // Handle errors here
    //
}
finally
{
    // Dispose the repl object
    //
    repl.Dispose();
}

Platforms

Windows CE, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows XP Professional x64 Edition, Windows XP SP2

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

Version Information

.NET Framework

Supported in: 3.0

.NET Compact Framework

Supported in: 2.0, 1.0

See Also

Reference

SqlCeReplication Class
SqlCeReplication Members
System.Data.SqlServerCe Namespace