InternetPassword Property

SqlCeReplication.InternetPassword Property

Specifies the password used when connecting to the SQL Server Compact Edition Server Agent.

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

public string InternetPassword { get; set; }
/** @property */
public String get_InternetPassword ()

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

public function get InternetPassword () : String

public function set InternetPassword (value : String)

Not applicable.

Property Value

The Internet Information Services (IIS) password string. The default is no password.

The InternetPassword property is required if the SQL Server Compact Edition Server Agent is configured to use Basic Authentication or Integrated Windows Authentication. When Integrated Windows authentication is used, InternetPassword is not passed across the network.

When using Basic Authentication, you should configure IIS to use Secure Sockets Layer (SSL) or Private Communication Technology (PCT) encryption to help protect the user's password. In the absence of SSL or PCT encryption, Basic Authentication transmits passwords across the network in an easily decryptable form. This is unsafe; always use SSL or PCT encryption to help protect passwords when using Basic Authentication.

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

SqlCeReplication repl = null;

try
{
    // Instantiate and configure SqlCeReplication object
    //
    repl = new SqlCeReplication();
    repl.InternetUrl = "http://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();
}

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.

.NET Framework

Supported in: 3.0

.NET Compact Framework

Supported in: 2.0, 1.0

Community Additions

ADD
Show:
© 2016 Microsoft