Merge Replication help

[wiadus]

Hi I am using VS 2008 and SQL server 2008. I can't find Publication in the Managemnet Studio win I right click the repliction or expand it. Can any one help me out on how to go about it. thanks

[petevick]

Hi,
have you created the publication??

There is a 'step-by-step' article here (http://msdn.microsoft.com/en-us/library/ms839425.aspx) and an article I wrote on the device side here (http://www.devbuzz.com/Articles/zinc_sql_merge_replication_pg1.aspx)

[wiadus]

Hi,
have you created the publication??

There is a 'step-by-step' article here (http://msdn.microsoft.com/en-us/library/ms839425.aspx) and an article I wrote on the device side here (http://www.devbuzz.com/Articles/zinc_sql_merge_replication_pg1.aspx)

Pete, Thanks for the site and your article, infact I can't create the publication because in SQL Server 2008, I can't find publication when I expand the replication or expand it. So if you could help sort it out. Thanks very much.

[petevick]

How are you creating the publication?
Local publications>New Publication should take you through the wizard.

Which version of SQL2008 are you using? Express does not support replication publication, only replication subscription

[wiadus]

How are you creating the publication?
Local publications>New Publication should take you through the wizard.

Which version of SQL2008 are you using? Express does not support replication publication, only replication subscription

I am using SQL 2008 Express. Does it mean I can't use it for the merge replication? I only have full version of SQL Server 2000 enterprise. Can I use it with the SQL Compact 3.5

[petevick]

SqlExpress can't be a publisher, only a subscriber.

To be a Publisher you need to full SQL Server. You SHOULD be able to use Sql Server 2000 enterprise as a publisher for Sql Server Ce

[wiadus]

Hi, I have download fuul version of the sql 2008 and I have set up the publication and the IIS and I can see it when I expand the server agent but in you article I have to test it with my IP ID. So how could I know my IP ID is it the same ip id I use to connect to my router or how do I test it has been configured correctly with the sql 2008 and sqlce 3.5. Because I don't know the ip Id to use I entered (http:// servername/Database/sscesa3.5.dll) and I got the following error
(Server Error in Application "DEFAULT WEB SITE"Internet Information Services 7.5
Error Summary
HTTP Error 404.0 - Not Found
The resource you are looking for has been removed, had its name changed, or is temporarily unavailable. Detailed Error Information
Module IIS Web Core
Notification MapRequestHandler
Handler StaticFile
Error Code 0x80070002
Requested URL http://workplace:80/shiftmanager/sscesa35.dll
Physical Path C:\inetpub\wwwroot\shiftmanager\sscesa35.dll
Logon Method Anonymous
Logon User Anonymous
Most likely causes:
•The directory or file specified does not exist on the Web server.
•The URL contains a typographical error.
•A custom filter or module, such as URLScan, restricts access to the file.
Things you can try:
•Create the content on the Web server.
•Review the browser URL.
•Create a tracing rule to track failed requests for this HTTP status code and see which module is calling SetStatus. For more information about creating a tracing rule for failed requests, click here.
Links and More InformationThis error means that the file or directory does not exist on the server. Create the file or directory and try the request again.
View more information )

Any help

[petevick]

you point at the shared folder so possibly....
http://localhost/shiftmanager/sqlcesa35.dll?diag

The attached screenshot should show all the info you need to set it up, even though this is for Sql2005

If shows the host address, the virtual folder, and the sharing needed with name

http://www.gui-innovations.com/misc/Replication.png

[wiadus]

Hi Pete, thanks for you article and help. I follow your article and the database is created on the device but when I make changes and try to synchronise it does not update the pc database. I have tried several times but still not synchronise. Any help

[petevick]

Do you get any error messages?
Are you making changes on the PC database or the device database?

Have you looked at the replication monitor?

Expand your local publications, right click on your publication and select Replication Montitor. In the window that opens, click on your server to show all the publications, and click on your publication.

That will show the history of what has happened - as per attached image.http://www.gui-innovations.com/misc/ReplicationMonitor.png

[wiadus]

HI Pete thanks for your time but the error from the publisher shows subscription 0 and synchronization 0 and on the devise I get error that, the synchronization can not send back to the computer running the IIS. Moreover when I was setting up the IIS I had a message that my snapshot folder is empty. I don't know if it could contribute to any thing.

[petevick]

Having an empty snapshot folder certainly would contribute - it means there is nothing to synchronise.

In Replication>Local Publications, right click on your database and do a 'View Snapshot Agent Status' and then click on the 'Start' button - that will generate your snapshots.

[wiadus]

In Replication>Local Publications, right click on your database and do a 'View Snapshot Agent Status' and then click on the 'Start' button - that will generate your snapshots.

Pete I deleted the publication and start a fresh one which the snapshot was generated and I configure the IIS but still not able to synchronize even though the db was created no problems. This is the error message from the device (A request to send data to the computer running IIS has failed. For more information, see HRESULT) . Sorry to bother you but I need help. Thanks

[petevick]

What is the Hresult?
Have you looked at the replication monitor?
Try replicating using a desktop application - the code should be the same.

Post your replication code here then we can take a look.

Mods - can we unmark this as resolved please?

Thanks :)

[wiadus]

I use the same code which is giving me problem on windows XP and it works. Could it be a problem with IIS in vista ie IIS 7?

[petevick]

It could be a problem in the way it is set up in IIS7.

We run replication on Server2008 using IIS7, but I didn't set it up. I know the guy who did had problems.

If you can see sscesa35.dll from your browser either from the device or from a desktop then it should work

[wiadus]

It could be a problem in the way it is set up in IIS7.

We run replication on Server2008 using IIS7, but I didn't set it up. I know the guy who did had problems.

If you can see sscesa35.dll from your browser either from the device or from a desktop then it should work
No I don't see it I continously getting error message and I look for the error from microsoft sit but after doing the suggestions is the same. But I am trying to do the replication on my laptop which I use most of the time but not on my desktop which is running Windows XP. So I am stack now

[petevick]

OK - if you don't see sscesa35.dll as shown in post #8 in this thread, then it is not set up correctly