Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Change Connection String at Runtime RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

        I have created a Windows Form application that uses SQL Server CE 3.5 databases. The databases sync to a remote SQL Server 2008 database using a WCF Service. Most of the code was generated using the Local Data Cache wizard. Everything works fine and syncs as expected. The Windows Form application can open different SQL Server CE 3.5 databases which all have the same schema and are provisioned for synchronization. Is it possible to change the connection string and scope name at runtime for synchronization of the SQL Server CE 3.5 databases back to the SQL Server 2008 database.

    Thanks

    Paul.

    Paul Wainwright

    Friday, April 24, 2015 11:51 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

        I have created a Windows Form application that uses SQL Server CE 3.5 databases. The databases sync to a remote SQL Server 2008 database using a WCF Service. Most of the code was generated using the Local Data Cache wizard. Everything works fine and syncs as expected. The Windows Form application can open different SQL Server CE 3.5 databases which all have the same schema and are provisioned for synchronization. Is it possible to change the connection string and scope name at runtime for synchronization of the SQL Server CE 3.5 databases back to the SQL Server 2008 database.

    Thanks

    Paul.

    Paul Wainwright


    The code generated using the Local Data Cache wizard creates uses a SyncAgent. Is there a way to change the scope name with SyncAgent?

    Paul Wainwright

    Monday, April 27, 2015 1:10 PM