SQL Server - Error: The cursor does not include the table being modified or the table is not updatable through the cursor.

Asked By dB. on 04-Sep-07 03:44 PM
We use a lot of virtual machines. I have a base VM with SQL 2005
installed. I rename this VM (i have multiple copies running) and run
an old application (VB code, iterates through recordsets, etc.).

I get: Microsoft][ODBC SQL Server Driver][SQL Server]Could not find
server '2K3VM-DG' in sysservers. Execute sp_addlinkedserver to add the
server to sysservers.

This makes sense, and I can fix it with sp_dropserver / sp_addserver
[local]. Good.

The next error is puzzling though:

[Microsoft][ODBC SQL Server Driver][SQL Server]The cursor does not
include the table being modified or the table is not updatable through
the cursor.

Any suggestions on how to fix this?




Aaron Bertrand [SQL Server MVP] replied on 04-Sep-07 03:47 PM
Maybe if you show the code?
sugu maran replied on 11-Sep-07 09:50 AM
I am also getting the same error. Any one knows the solution for that particular error?? Please help me..