Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

varbinar(max) to long binary sync ODBC error

38 views
Skip to first unread message

Jason

unread,
Sep 22, 2011, 11:05:43 AM9/22/11
to
Mobilink 12.0.1.346
Synchrinizing to Ultralite 12.0.1.346
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> [10050] 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> [10050] 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?

Thanks!

0 new messages