Row cannot be located for updating
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.
Make sure you have a backup of your registry information before attempting any editing of the registry contents. This removes the 255 character limitation on bound parameters.The most important advantage is that we can scope it to database level rather than setting it at the instance level.This makes it possible for us to have other databases co-existing in the same server instance with new behavior enabled i.e. For more information, see Can't connect to [local] My SQL server.The following error is reported when using transactions: .