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
asked 27 Mar '12, 11:37
We've seen that SQL Server error before when a large column is not the last column. A future release of our documentation will include a note like the following:
Since you mentioned sync models, did you add the columns to your synchronization and then redeploy it?
If not, that can cause problems from outdated ml_column entries. Sync model deployment adds rows to MobiLink's ml_column table in a particular order, via ordered calls to ml_add_column.
You can call that stored procedure for each synchronized table with
FYI, in version 12 column names are sent by default. Since you didn't mention which version and build of UltraLite and MobiLink you are using, you may have to enable it.
answered 27 Mar '12, 13:15
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:
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.