Invalid Descriptor Index

[Former Member]

Hello, I had a working mobilink sync (MSSQL Server 2008 and Ultralite) and I added a couple of columns to my download script. After the change i started getting E. <4> [-10002] Consolidated database server or ODBC error: ODBC: [Microsoft][SQL Server Native Client 10.0]Invalid Descriptor Index (ODBC State = 07009, Native error code = 0, Column or parameter #17) Even when i removed the newly added columns i kept on getting that error and whatever i did the error doesn't disappear. Do you have any idea what can be causing the problem or is there a way to clean all sync models from my database and reset the Mobilink

[Former Member]

If your download_cursor script returns BLOBs and the script is written as a stored procedure call, you need to put all the BLOB columns at the end of the result set. Please see:

http://support.microsoft.com/kb/238080

Otherwise, please post your table definition and the download_cursor script.

There is no such a restriction, if the script is written as a plain "SELECT" statement.