locked
Syncing SQL Anywhere 12 databases RRS feed

  • Question

  • When setting the DbSyncProvider.Connection with a newly created OdbcConnection we have success. 

    When setting the DbSyncProvider.Connection with a newly created SAConnection  we have the failure – “The connection object is not valid. Cannot create a new instance of the connection object”

    The same connection string is being used.

    OdbcConnection and SAConnection are both IDbConnection compatible as is DbSyncProvider.Connection

    On the SQL Anywhere 12 side,

    • We are using “iAnywhere.Data.SQLAnywhere.v4.5”.  I have attempted this with “.v2.0” and “.v4.0” as well.

    Doesn't matter if the app is compile for x86 or x64 platforms.

    We are using Microsoft Sync Framework references

    • Microsoft.Synchronization, vers 2.1
    • Micorsoft.Synchronization.Data, vers 3.1
    • Microsoft.Synchronization.Metadata.Storage, vers 2.1

    The SAConnection does Open and I am able to run an SACommand query with it.

    Why can’t DbSyncProvide.Connection be set by SAConnection when OdbcConnection works?

    Friday, December 18, 2015 5:08 PM