Getting error "The provider does not have the required command 'SelectScopeInfoCommand' specified.". I already have a application that sync the same database using SqlSyncProvider without setting up and commands for it. Something weird using it within
WCF started happening. Can anybody please advise?
Trace:
VERBOSE, WCFWindowsServiceHosting, 8, 12/12/2012 04:13:23:716, Reading Schema Version Info
VERBOSE, WCFWindowsServiceHosting, 8, 12/12/2012 04:13:23:716, Executing Command: SELECT [schema_major_version], [schema_minor_version], [schema_extended_info] FROM [schema_info]
ERROR , WCFWindowsServiceHosting, 8, 12/12/2012 04:13:23:732, Missing command 'SelectScopeInfoCommand'
ERROR , WCFWindowsServiceHosting, 8, 12/12/2012 04:13:23:732, Caught exception while getting scope: Microsoft.Synchronization.Data.DbMissingCommandException: The provider does not have the required command 'SelectScopeInfoCommand' specified.
at Microsoft.Synchronization.Data.SqlServer.SqlSyncScopeHandler.ReadScope(IDbConnection connection, IDbTransaction transaction, ReadKnowledgeType readType, ReadForgottenKnowledgeType readFKtype)
at Microsoft.Synchronization.Data.RelationalSyncProvider.GetScope(DbSyncSession DbSyncSession)
VERBOSE, WCFWindowsServiceHosting, 8, 12/12/2012 04:13:23:732, Closing Connection