none
Change Connection String at Runtime RRS feed

  • Question

  • 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

  • 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