locked
Merge Replication and SQL 2005, help! RRS feed

  • Question

  • I'm working on developing a software solution using Mobile Client Software Factory. Let me start off by saying that this package is such a dream come true, and I can't thank the guys who put this together enough. The problem is, we're having some trouble getting the components setup for the Framework to work, in particular with SQL Server 2005.

    We have SQL Server 2005 running on a machine, and we have our entire database setup what I believe to be correctly. Last night, we tried for hours to get the PPC Emulator running our version of the Framework to connect to the SQL Server (On another machine on the same LAN) to no avail. 

    We published just one table to test with, we have the snapshot created, the web service is running, and yet it won't let us connect. The most common error we're getting from the webservice log is: Hr=80004005 ERR:OpenDB failed getting pub version 28627. 

    I was just wondering if someone out there had a guide for correctly setting up SQL Server 2005 for merge replication so that remote clients can access the server through the webservice over the internet. If there is anything specifically special that needs to be done to work with the Mobile Client Software Factory, that would be great to know too. 

    I'd really appreciate some help, and thanks in advance to anyone who can lend some advice.

    Cheers!

    Andrew

    Wednesday, August 9, 2006 6:30 PM

Answers

  • I don't know what Mobile Client Software Factory is, but if you have merge subscriptions on a disconnected network, but has access to the internet, you can use merge web synchronization, which is synchronizing over the internet.  There's more information in books online, search for replication web synchronization.
    Thursday, August 10, 2006 7:15 PM