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?
Did you selected the Allow InProcess option for the linked server?
You may also receive this error message if you have not selected the Allow InProcess option for the linked server. To select this option, in the Linked Server Properties dialog box, click Provider Options, and then click to select Allow InProcess.
TechNet Community Support