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?
