Skip to content

Force_No_Scroll_Cursors=ON Produce Delete Error using OpenQuery

August 1, 2012



A common procedure of the ETL process is to move data from the data source to the staging area. It is a frequent practice to delete all the content of the staging table before loading the new data. When deleting data in Sybase IQ 15.2 from MS SQL Server 2005 using openquery through linkservers, the delete command produce an error if the Force_No_Scroll_Cursors option is set to ON.


Description of the error


When executing the command

‘select * FROM DBA.MyTable’)


from MS SQL Server 2005, the following error is encounter:

Msg 7330, Level 16, State 2, Line 1

Cannot fetch a row from OLE DB provider “SAOLEDB.11” for linked server “PRODIQDB”.


Note that MYIQDB is a Sybase IQ LinkServer.




On the Sybase IQ Server, set the Force_No_Scroll_Cursors option to OFF




Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: