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
Get
Set
'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);
}
member PublisherAddress : string with get, set
function get PublisherAddress () : String
function set PublisherAddress (value : String)
Property Value
Type: System. . :: . .String
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 Replication Provider communicates with the Publisher. For example, if the 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').
Examples
The following example sets the PublisherAddress property of the SqlCeReplication object.
Dim repl As SqlCeReplication = Nothing
Try
' Instantiate and configure SqlCeReplication object
'
'NOTE: when possible, prompt users to enter security
'credentials at runtime. If you store credentials in a file,
'you must secure the file to prevent unauthorized access.
'
repl = New SqlCeReplication()
repl.InternetUrl = "https://www.adventure-works.com/sqlce/sqlcesa35.dll"
repl.InternetLogin = "MyInternetLogin"
repl.InternetPassword = "<enterStrongPassword>"
repl.Publisher = "MyPublisher"
repl.PublisherDatabase = "MyPublisherDatabase"
repl.PublisherLogin = "MyPublisherLogin"
repl.PublisherPassword = "<enterStrongPassword>"
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
//
//NOTE: when possible, prompt users to enter security
//credentials at runtime. If you store credentials in a file,
//you must secure the file to prevent unauthorized access.
//
repl = new SqlCeReplication();
repl.InternetUrl = "https://www.adventure-works.com/sqlce/sqlcesa35.dll";
repl.InternetLogin = "MyInternetLogin";
repl.InternetPassword = "<enterStrongPassword>";
repl.Publisher = "MyPublisher";
repl.PublisherDatabase = "MyPublisherDatabase";
repl.PublisherLogin = "MyPublisherLogin";
repl.PublisherPassword = "<enterStrongPassword>";
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();
}