SqlCeReplication Constructor (String, String, String, String, String, String, String, String, String, String)

Inicializa una instancia nueva del objeto SqlCeReplication y establece sus propiedades para la conexión a una publicación.

Espacio de nombres: System.Data.SqlServerCe
Ensamblado: System.Data.SqlServerCe (en system.data.sqlserverce.dll)

Sintaxis

'Declaración
Public Sub New ( _
    internetUrl As String, _
    internetLogin As String, _
    internetPassword As String, _
    publisher As String, _
    publisherDatabase As String, _
    publisherLogin As String, _
    publisherPassword As String, _
    publication As String, _
    subscriber As String, _
    subscriberConnectionString As String _
)

public SqlCeReplication (
    string internetUrl,
    string internetLogin,
    string internetPassword,
    string publisher,
    string publisherDatabase,
    string publisherLogin,
    string publisherPassword,
    string publication,
    string subscriber,
    string subscriberConnectionString
)

public:
SqlCeReplication (
    String^ internetUrl, 
    String^ internetLogin, 
    String^ internetPassword, 
    String^ publisher, 
    String^ publisherDatabase, 
    String^ publisherLogin, 
    String^ publisherPassword, 
    String^ publication, 
    String^ subscriber, 
    String^ subscriberConnectionString
)

public SqlCeReplication (
    String internetUrl, 
    String internetLogin, 
    String internetPassword, 
    String publisher, 
    String publisherDatabase, 
    String publisherLogin, 
    String publisherPassword, 
    String publication, 
    String subscriber, 
    String subscriberConnectionString
)

public function SqlCeReplication (
    internetUrl : String, 
    internetLogin : String, 
    internetPassword : String, 
    publisher : String, 
    publisherDatabase : String, 
    publisherLogin : String, 
    publisherPassword : String, 
    publication : String, 
    subscriber : String, 
    subscriberConnectionString : String
)

Parámetros

• internetUrl
  Dirección URL utilizada al realizar la conexión con el agente del servidor SQL Server Compact 3.5.

• internetLogin
  Nombre de inicio de sesión utilizado al realizar la conexión con el agente del servidor SQL Server Compact 3.5.

• internetPassword
  Contraseña utilizada al realizar la conexión con el agente del servidor SQL Server Compact 3.5.

• publisher
  Nombre del publicador.

• publisherDatabase
  Nombre de la base de datos de publicación.

• publisherLogin
  Nombre de inicio de sesión que se utiliza para conectarse al publicador.

• publisherPassword
  Contraseña de inicio de sesión que se utiliza para conectarse al publicador.

• publication
  Nombre de la publicación que se ha habilitado para suscripciones de mezcla anónimas.

• subscriber
  Nombre del suscriptor.

• subscriberConnectionString
  Cadena de conexión OLE DB para la base de datos de SQL Server Compact 3.5 en el dispositivo basado en Windows Mobile.

Ejemplo

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();
}

Plataformas

Plataformas de desarrollo

Windows Vista, Windows Mobile 5.0, Windows XP Professional with Service Pack 2 (SP2), Windows Server 2003, Windows Mobile 2003 for Pocket PC, Windows CE 5.0
Información de la versión
.NET Framework y NET Compact Framework
Se admite en 3.5
.NET Framework
Se admite en 3.0
.NET Compact Framework y .Net Framework
Se admite en 2.0

Vea también

Referencia

SqlCeReplication Class
SqlCeReplication Members
System.Data.SqlServerCe Namespace