none
Updating a SQL Anywhere database via pass-through tables in SQL Server

    Question

  • We have a web server that uses a SQL Anywhere ("SQLA") database and a SQL Server database with views to the SQLA tables. I am trying to update the SQLA tables using the SQL Server views and I get this error:

    "OLE DB provider "MSDASQL" for linked server "ROSESQL" returned message "[Sybase][ODBC Driver][SQL Anywhere]Cursor option values changed".
    Msg 7320, Level 16, State 2, Line 1
    Cannot execute the query "select * from ottaco..property_details" against OLE DB provider "MSDASQL" for linked server "ROSESQL". The provider could not support a row lookup position.The provider indicates that conflicts occurred with other properties or requirements.The provider could not support a required row lookup interface.The provider indicates that conflicts occurred with other properties or requirements."

    I read on the forum that the SQLA tables need to have unique indexes, which they do. Does anyone have a suggestion?

    Thank you.

    Friday, June 13, 2014 1:29 PM

All replies