varbinar(max) to long binary sync ODBC error - 09-22-2011 , 10:05 AM
Synchrinizing to Ultralite 18.104.22.1686
Consolidate Database: Mircrosoft Sql Server 2008 R2
My consolidated database has a table which holds small icons in a "varbinary(max)" column. This is replicated as a "long binary" to my ultralite databases. They sync ok, but my ODBC driver (SQL Server Native Client 10.0 2009.100.1600.01) throws the following errors to the mobilink server on the download and download_delete scripts:
W. 2011-09-22 10:32:17. <1>  ODBC: [Microsoft][SQL Server Native Client 10.0]Cursor type changed (ODBC State = 01S02, Native error code = 0)
W. 2011-09-22 10:32:17. <1>  ODBC: [Microsoft][SQL Server Native Client 10.0][SQL Server]Executing SQL directly; no cursor. (ODBC State = 01000, Native error code = 16954)
This does not happen on other tables, and the error does not occur when I remove the varbinary(max) column from sync. Any ideas?