Row cannot be located for updating sql server idating com

01 Feb

The rowset was using optimistic concurrency and the value of a column has been changed after the containing row was last fetched or resynchronized.

ADO, compared to the BDE, has taken a more practical approach to the problem.The solution required tweaking a small setting in the ODBC DSN property as shown below Once we set the Return matched rows instead of affected rows option the UPDATE query executed successfully.This setting will allow the updating of values in My SQL to the fields which has a value already.This blog explains an issue you're likely to face while executing a remote UPDATE query against a My SQL server over a linked server connection using ODBC DSN based connectionstring Recently I was working in a project where I required data to be transferred from a remote server and do some manipulations with it.The status column in the remote server table have to be updated later.