Re: Replication problems

From: pat (pat_at_discussions.microsoft.com)
Date: 09/11/04

  • Next message: pat: "Re: Replication problems" 
    Date: Sat, 11 Sep 2004 09:11:06 -0700

    Dear Mr. Collins!

    I still work on the sample from this site
    http://www.msdn.microsoft.com/SQL/SQLCE/default.aspx?pull=/msdnmag/issues/03/09/datapoints/default.aspx to get work on my local machine and on my PocketPc.

    I have now changed the sample code once more a little bid in that way:

    //Set up the Replication properties
    oRpl = new SqlCeReplication();
    oRpl.Publisher = "ACHATSCHITZ";//achatschitz is my MachineName
    oRpl.PublisherLogin = "sa"; //sa is the user to gain access to a database of
    the SQL Server with the sa as passwod.
    oRpl.PublisherPassword = "sa";
    oRpl.InternetUrl = "http://ACHATSCHITZ/pat/sscesa20.dll"; //pat is the alias
    of my created virtual directory.
    oRpl.InternetLogin = "iusr_ACHATSCHITZ";
    oRpl.InternetPassword = "";
    oRpl.Subscriber = "CESubscriberTest";
    oRpl.Publication = "NorthwindPub";
    oRpl.PublisherDatabase = "Northwind";
    oRpl.SubscriberConnectionString =
     "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=" +
    this.m_sDataSource;
                    
    DialogResult oResponse = DialogResult.Yes;

    But i still receive two errors when i execute the application:

    Error #1 of 2
    Error Code: -2147467259
    Message: A call to SQL Server Reconciler failed.[,,,,]
    Minor Err.: 29006
    Source: Microsoft SQL Server 2000 Windows CE Edition

    Error #2 of 2
    Error Code: -2147201001
    Message: The process could not deliver the snapshot to the Subscriber.
    Minor Err.: 0
    Source: Merge Replication Provider

    I looked already in the msdn for these errors but i did not find something
    useful. Please don't let me hang and answer me again, i think i could not
    work this out with out your help.:((

    regards

    patrick

    PS: The only settings for the Replication i made were the creation of the
    virtual directory and the creation of the publication, as quoted in your
    doc-file and in the quoted url at the top of my posting.

  • Next message: pat: "Re: Replication problems"

    Relevant Pages

    • RE: Replication Problem
      ... I have now changed the sample code once more a little bid in that way: ... A call to SQL Server Reconciler failed. ... Source: Merge Replication Provider ... doc-file and in the quoted url at the top of my posting. ...
      (microsoft.public.sqlserver.replication)
    • Re: Transactional replication from SQL Server 2005 to SQL Server 7 - how?
      ... SQL Server 7.0 from the SQL2005 management tools but I would encourage to ... primary keys are replicated as unique indexes if you ... configure replication using the SQL2000 Enterprise Manager. ... If you plan to reinitialize your SQL2000->SQL2005 subscription in the ...
      (microsoft.public.sqlserver.replication)
    • Re: High Availability
      ... also does failover. ... Async replication is real-time, as opposed to the scheduled Log Shipping ... > Note that one of the considerations for the active/passive GEO Cluster is ... > SQL Server 2000 High Availability Series ...
      (microsoft.public.sqlserver.clustering)
    • Re: Snapshot Creation
      ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... The Microsoft AD account under which the Snapshot agent (and other ...
      (microsoft.public.sqlserver.replication)
    • Re: QUEUE READER - A FREQUENT PROBLEM!
      ... "Hilary Cotter" wrote: ... Looking for a SQL Server replication book? ... queue table and the same transaction coldn't be inserted at the ...
      (microsoft.public.sqlserver.replication)
    Loading