Microsoft Synchronization Services for ADO.NET... Install on Server?

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 it's not pushing up to the 05 SQL Server.

Everything works on my dev box but not when publish/deployed.

Any ideas?

Thanks a ton!

Bill

[501 byte] By [billb59] at [2008-2-8]
# 1

Hi Bill,

You will need to install Sync Services on the same machine as SQL Server if you have the server provider installed on that machine and exposed to clients through a web service (like in the web service demo).

If your client and server providers are on client machine then you don’t need to install sync services runtime on the SQL Server box.

Thanks

RafikRobeal at 2007-9-7 > top of Msdn Tech,Visual Studio Orcas,Microsoft Synchronization Services for ADO.NET...
# 2

Very cool... thanks again!! :)

billb59 at 2007-9-7 > top of Msdn Tech,Visual Studio Orcas,Microsoft Synchronization Services for ADO.NET...
# 3

u da man!

will this connection work when deployed?

<connectionStrings>

<add name="ffgsCRM.My.MySettings.ffgscrmConnectionString3" connectionString="Data Source =C:\Documents and Settings\Administrator\Local Settings\Application Data\ffgsCRM.sdf"

providerName="Microsoft.SqlServerCe.Client" />

</connectionStrings>

If not... what should I use to path to this directory... have not had an anwser that worked yet... any ideas?

Thanks a ton man! :)

billb59 at 2007-9-7 > top of Msdn Tech,Visual Studio Orcas,Microsoft Synchronization Services for ADO.NET...
# 4

This is the connection string for the client database. I don't think you need that on the web service. The connection string for the web service should be for the server database which cannot be SQLCE.

Thanks

RafikRobeal at 2007-9-7 > top of Msdn Tech,Visual Studio Orcas,Microsoft Synchronization Services for ADO.NET...
# 5

My bad... the path was easier than i made it.... sorry guys and girls... :(

billb59 at 2007-9-7 > top of Msdn Tech,Visual Studio Orcas,Microsoft Synchronization Services for ADO.NET...

Visual Studio Orcas

Site Classified