Recent update: 2008-3-21
Hi, i'm new to this SSCE but i'm interested of what it can do, so i did some readings and experimenting with different database, but i was hit by a problem and would like someone who's kind enough to explain to me.do all syncsession's strings (SyncClientIdHash,SyncNewReceivedAnchor, etc) ...
Hi I am developing an application on windows mobile 5.0 environment and using VS 2005 for the same. I thought of making use Microsoft ADO.Net synchronization services for sync funcionality. I am trying to make use of the same code as available in OfflineAppDemo-TSQL+SProc but trying to ...
1365 byte By
CraigH at 2008-3-5
Hi All After working through the various demos, we've started using Sync Services to sync data between Sql Server Express Edition and Compact Edition. We create the schema in SSCE manually using DDL rather than using the SyncSchema functionality. All looked good until we wanted to update the ...
557 byte By
ShawnC at 2008-3-3
Currently we are in the process of developing an application that has two parts: A)desktop version B)mobile version. Both versions use sqlce 3.x but we are trying to figure out a way for these two versions to sync data. Is type of scenario in the plans or are we crazy? We don't need the extra ...
In my application, it makes sense to have certain business rules reside on the client as this can reduce server traffic that would normally be rejected for violating business logic. Click-once deployment would take care of updating the logic modules on the very rare occasions they would change. ...
Hi I am using SQL server 2005. I created a publication in server and created a subscription in SQL Mobile. After creating the subscription I synchronize it from SQL Mobile (subscription). It is working good. The synchronization happens both side. How can i synchronize the data from ...
When trying to run the samples, everything works ok until I hit the Synchronize button. Then I get the following error: Unable to find an entry point named 'ME_SetTransactionFlag' in DLL 'sqlceme30.dll'. I am running the samples on a Windows XP SP2, with System.Data.SqlServerCe.dll version ...
Hi I am currently in the Requirement Gathering phase of a project where it seems that 'Microsoft Synchronization Services for ADO.NET' would be rather useful. I am not sure what the licensing issues are , i.e. if I want to use it in a production environment (both for Microsoft ...
712 byte By
SimonK at 2008-2-25
I'm investigating whether I can use Synchronization Services over a transport infrastructure where client and server never communicate directly. Essentially, I have an existing infrastructure that allows files to be passed to and from server and client, and for method calls to be made, but the ...
132 byte By
Ocherk at 2008-2-24
Hello, what about your plans to develop services for sqlserver on both ends but not only SQL CE? Thank you.
Hi! when I target my server project on the WCF Webservice (with the synchronization designer of Orcas), it doesn't create the "contract" class (named NorthwindCache.Server.SyncContract.vb in Steve Lasker's demo). Do you have an idea about that? Can I create it manually and how (in ...
Hi! I show the video from Steve Lasker, and reproduce his example.... it works, but I don't understand the use of DataSets! Why is the designer generate a DataSet ? Is it not possible to use only the SQLce database? thx, ++
Hi, In rda pull push, I had a problem with Norton Internet security 2006. It gave an error -"Header information is either corrupted or missing". I found from blogs that the following was the cause: "This problem happens because Norton Internet Security strips off the ...
Hi!! I followed the article of Rafik to make my first synchronization between SQL 2005 and SQLce. Everything works fine, BUT I've a little problem with primary and foreign keys... I've 3 tables : create table Person ( id uniqueidentifier not null,firstName nvarchar(25) null,lastName ...
Steve Lasker has posted Additional Q&A on the Visual Studio Orcas Sync Designer (March 21, 2007) and First look at the Visual Studio Orcas Sync Designer (March 22, 2007) on his blog. Steve added part 2 of the screencast: Going N Tier w/WCF, Synchronizing data using Sync Services for ADO.NET ...
7078 byte By
ChadQ at 2008-2-19
I am in the process of running through the N-Tier example and have run into a problem. I have successfully run a test using Bi-Directional syncing through an asp.net webservice, however, when I try to test the UploadOnly Sync Dircection I receive the following error from the Web ...
HiI am using SQL server 2005. I created a publication in server and created a subscription in SQL Mobile. After creating the subscription I synchronize it from SQL Mobile (subscription). It is working good. The synchronization happens both side.How can i synchronize the data from ...
For my Stored Proc I'm using for the SelectIncrementalInsertsCommand, I want to pass in more than just SyncClientIdHash, SyncLastReceivedAnchor, SyncNewReceivedAnchor. How do I pass in additional parameters? And I guess a more specific question would be, how/where are the values for the ...
We really want to continue using the Web Service Syncing method with SQL Compact but wont be able to unless Blob syncing is possible through a webservice. Has anyone synced binary objects vs. straight text with the Web Service method? Any help or guidance in a direction is appreciated! Thanks.
Hi!!I followed the article of Rafik to make my first synchronization between SQL 2005 and SQLce. Everything works fine, BUT I've a little problem with primary and foreign keys...I've 3 tables :create table Person (id uniqueidentifier not null,firstName nvarchar(25) null,lastName nvarchar(25) ...
Thanks for the great article you posted on code project[1]. Well done, other than you may want to fix the triggers in the sample because they are horribly broken if more than 1 record is inserted or updated, and I worry that people will just copy paste without knowing it."Take Data Offline ...
Hi I'm trying Web Service Off line Application Demo.I have noticed that if i manually insert or update record in sql ce then that update doesn't synchronize with the sql server.But at the same time if I try random insert or update to update sql ce from application then it synchronize ...
I need more information on this API to see if i can use it in my app. Where can i find more detailed information, documentation? I can't seem to find detailed information about it. I need to make the application working in a disconnected environment. The user play with the application at home ...
Hello sync ladies and gents... :) Quick question for documentation.What is the SQL Server 2005 user access minimum (what access permissions do I need to assign to a networked user group created in SQL Server 2005 for the current sync database...) for ADO.NET SYNC Services to work? The ...
Hi,I am using DB2 on server and SQL CE on client and we are not able to perform the sync using Microsoft Synchronization Services, though the code work fine with SQL server at server end.We had tried with OLEDB and DB2 Data provider, with OLEDB we are able to insert one row in table but all ...
Hey all.. need some help understanding the below SelectClientIdCommand ... How would you write the below for deployment so all clients sync with a SQL 05 Server? ' get client mac address for update_originator_id and clientIdCmdDim GetMac As StringGetMac = GetMacAddr().ToString' select new ...
Hey all.. need some help understanding the below SelectClientIdCommand ... How would you write the below for deployment so all clients sync with a SQL 05 Server? ' get client mac address for update_originator_id and clientIdCmdDim GetMac As StringGetMac = GetMacAddr().ToString' select new ...
Rafik,I managed to get my deployment issues worked out and running very well after moving the path out of the users folder. The sync class table data is being uploaded to the server from client inserts... the server creating the client database... Very cool stuff!Here's whats currently going ...
Hi all,I just posted the forth demo in the series. This demo extends the previous demos and adds conflict handling logic. Conflicts are fact of life in occasionally connected synchronization scenarios. As a sync developer, you need to find a way to deal with this type of changes that if applied ...
Hi,I am using DB2 on server and SQL CE on client and we are not able to perform the sync using Microsoft Synchronization Services, though the code work fine with SQL server at server end.We had tried with OLEDB and DB2 Data provider, with OLEDB we are able to insert one row in table but all ...
Rafik, I managed to get my deployment issues worked out and running very well after moving the path out of the users folder. The sync class table data is being uploaded to the server from client inserts... the server creating the client database... Very cool stuff! Here's whats currently ...
Subj. If I have SQL Server 2005 on the client can I use your service?My situation:Client: intranet web-site on ASP.NET 2.0 + SQL Server 2005.Server: internet web-site on ASP.NET 2.0 + SQL Server 2005.All main works and complete datas stores in a client. And weekly I need to sync partially data ...
When trying to run the samples, everything works ok until I hit the Synchronize button. Then I get the following error: Unable to find an entry point named 'ME_SetTransactionFlag' in DLL 'sqlceme30.dll'. I am running the samples on a Windows XP SP2, with System.Data.SqlServerCe.dll version ...
Rafik, Good morning!Do I need to install Microsoft Synchronization Services for ADO.NET (SSCERuntime-ENU.msi ) on the 05 SQL Server? I've deployed my application on the network and it seems my clients are not showing data.. the database is created and inserts are working on the client but ...
When trying to run the samples, everything works ok until I hit the Synchronize button. Then I get the following error:Unable to find an entry point named 'ME_SetTransactionFlag' in DLL 'sqlceme30.dll'.I am running the samples on a Windows XP SP2, with System.Data.SqlServerCe.dll version ...
Hi!What's the main difference between SQLce and SQLee ?Does SQLce support xml data querying?Thx for anwser!PlaTyPuS Here is the answer : http://blogs.msdn.com/stevelasker/archive/2006/11/08/comparing-sql-server-express-and-compact-editions-whitepaper.aspx And SQLce doesn't support xml data ...
yo snyc bros... :) have a quick question in regards to deployment using ClickOnce... Microsoft Synchronization Services for ADO.NET is not installing on the client machine from ClickOnce... can anyone point me in the right direction on how to deploy ADO.NET sync services? I've included the ...
1570 byte By
CraigH at 2008-2-7
Hi AllFirstly, just to say that I'm pleased to have found Sync Services in the past few weeks as we were about to start implementing something in-house to perform a similar task. The Sync Services code in demo 3 seems to meet our needs very well. We need to sync data to and from a smart client ...
<P><FONT color=#0000ff size=2><FONT face=Tahoma,Helvetica,Sans-Serif color=#000000 size=3>my bad... post was wrong.. sorry!</FONT></FONT></P>
554 byte By
ShawnC at 2008-2-6
Currently we are in the process of developing an application that has two parts: A)desktop version B)mobile version. Both versions use sqlce 3.x but we are trying to figure out a way for these two versions to sync data. Is type of scenario in the plans or are we crazy?We don't need the extra ...
Subj. If I have SQL Server 2005 on the client can I use your service?My situation:Client: intranet web-site on ASP.NET 2.0 + SQL Server 2005.Server: internet web-site on ASP.NET 2.0 + SQL Server 2005.All main works and complete datas stores in a client. And weekly I need to sync partially data ...
Hey fellow snyc dudes and dudettes... :) Anyone had any trouble using a dataset for return values in a datagridview for the client app?trying to make this work... ' Open the Connection For SQL Compact Edition Dim cn As New SqlServerCe.SqlCeConnection("Data Source = " & ...
In the Web Service Sync demo you have to modify the Resource.cs to use the ADO.NET Sync objects. We use Windows communcation foundation and was wondering how this would be done, since I assume the WCF DataContract would be different than the Sync types?Are you planning a WCF example in the ...
Hey fellow snyc dudes and dudettes... :) Anyone had any trouble using a dataset for return values in a datagridview for the client app?trying to make this work... ' Open the Connection For SQL Compact Edition Dim cn As New SqlServerCe.SqlCeConnection("Data Source = " & ...
I'm working on a Smart Client application using .NET 2.0, SQL CE 3.1, and SQL Server 2005. The sync technology I'm using is merge replication, but as is specified on several sites related to the new Synchronization Services, having so little control over the process is frustrating at times.My ...
I'm exploring writing my own ClientSyncProvider to support a 3rd party database on the client. Is there any documentation out there describing the abstract class? Thanks Joe </span>
</P> user error and mismatch datatype in the database... thanks.</P> </P> </P>
Hi Everyone,I've created a vb.net app based on the n-tier design where my webservice is located on a Windows 2003 server running IIS6. My SQL Server database is on another server running Windows 200 Server and my client is Windows XP. I'm sync'ing about 20 tables with 1 of them containing ...
</P> Hey sync team... love this stuff! </P> Quick question on the Microsoft.Synchronization.Data.Server.SyncDataColumnCollection... </P> What is the DataColumns Capacity limit... 32? If not, what is the largest it can do within reason?</P> Thanks,</P> Bill</P>
Hello, fellow developers!In my scenario I have two databases (mentioned as "internal" and "external") separated by a firewall, that are required to stay in synch. The "internal" database is residing on such machine that is allowed only outbound connections.Both machines are running SQL 2005 ...