Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
Microsoft Synchronization Services for ADO.NET... Install on Server?

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

  • Monday, March 12, 2007 1:19 PM
     
     
    Sign In to Vote
    0

     

    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

     

    • Moved by Max Wang_Chinasoft Friday, April 22, 2011 11:11 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    •  
       

    All Replies

    • Monday, March 12, 2007 4:23 PM
       
       Answered
      Sign In to Vote
      0

      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

         
      • Monday, March 12, 2007 4:29 PM
         
         
        Sign In to Vote
        0

        Very cool... thanks again!! :)

         

         

         

           
        • Monday, March 12, 2007 4:33 PM
           
           
          Sign In to Vote
          0

           

          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! :)

             
          • Monday, March 12, 2007 6:02 PM
             
             
            Sign In to Vote
            0

             

            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

               
            • Monday, March 12, 2007 6:10 PM
               
               
              Sign In to Vote
              0

               

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