SqlCeReplication コンストラクター (String, String, String, String, String, String, String, String, String, String)

  • [アーティクル]

SqlCeReplication オブジェクトの新しいインスタンスを初期化し、パブリケーションに接続するためのプロパティを設定します。

名前空間:  System.Data.SqlServerCe
アセンブリ:  System.Data.SqlServerCe (System.Data.SqlServerCe.dll)

構文

'宣言
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 _
)
'使用
Dim internetUrl As String
Dim internetLogin As String
Dim internetPassword As String
Dim publisher As String
Dim publisherDatabase As String
Dim publisherLogin As String
Dim publisherPassword As String
Dim publication As String
Dim subscriber As String
Dim subscriberConnectionString As String

Dim instance As New SqlCeReplication(internetUrl, _
    internetLogin, internetPassword, _
    publisher, publisherDatabase, publisherLogin, _
    publisherPassword, publication, _
    subscriber, 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
)

new : 
        internetUrl:string * 
        internetLogin:string * 
        internetPassword:string * 
        publisher:string * 
        publisherDatabase:string * 
        publisherLogin:string * 
        publisherPassword:string * 
        publication:string * 
        subscriber:string * 
        subscriberConnectionString:string -> SqlCeReplication

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

パラメーター

  • internetUrl
    型: System. . :: . .String
    SQL Server Compact 3.5 サーバー エージェントに接続するときに使用する URL。
  • internetLogin
    型: System. . :: . .String
    SQL Server Compact 3.5 サーバー エージェントに接続するときに使用するログイン名。
  • internetPassword
    型: System. . :: . .String
    SQL Server Compact 3.5 サーバー エージェントに接続するときに使用するパスワード。
  • publisherLogin
    型: System. . :: . .String
    パブリッシャへの接続時に使用するログイン名。
  • publisherPassword
    型: System. . :: . .String
    パブリッシャへの接続時に使用するログイン パスワード。
  • publication
    型: System. . :: . .String
    匿名マージ サブスクリプションで使用可能なパブリケーション名。
  • subscriberConnectionString
    型: System. . :: . .String
    Windows Mobile ベースのデバイス上の SQL Server Compact 3.5 データベースに接続するための OLE DB 接続文字列。

使用例

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

関連項目

参照

SqlCeReplication クラス

SqlCeReplication メンバー

SqlCeReplication オーバーロード

System.Data.SqlServerCe 名前空間