CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    May 2008
    Posts
    74

    sincronize between sql server 2000 and sql server ce

    hi,
    i have a sql server 2000 database
    and a pocket pc running a sql server ce database
    now i looking for a way to sincronize both db.
    i have seen some tuturials but i don´t have
    all files that referers on tuturial.
    for example i have seen this:

    http://ondotnet.com/pub/a/dotnet/200...6/sqlce20.html

    that have this code for acess and sincronize:

    repl = New SqlCeReplication()
    repl.InternetUrl = "http://server/sqlce/sscesa20.dll"

    but i don´t have this dll---> sscesa20.dll
    and don´t know thats for

    repl.InternetLogin = "MyLogin"
    repl.InternetPassword = "<MyPassword>"
    repl.Publisher = "MyPublisher"
    repl.PublisherDatabase = "MyPublisher Database"
    repl.PublisherLogin = "MyPublisher Login"
    repl.PublisherPassword = "<MyPublisher Password>"
    repl.Publication = "MyPublication"
    repl.SubscriberConnectionString = "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=\ssce.sdf"
    repl.Subscriber = "MySubscriber"


    any one know a recent tuturial that work with sql server 2000 and sql server ce?
    thanks a lot for your help

  2. #2
    Join Date
    Jan 2006
    Location
    Fox Lake, IL
    Posts
    15,007

    Re: sincronize between sql server 2000 and sql server ce

    SQL 2000 is old, and might not even be able to sync.
    David

    CodeGuru Article: Bound Controls are Evil-VB6
    2013 Samples: MS CODE Samples

    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured