thank you for your provider options!

instead to remove optimistic update problem:

configure mysql-odbc to return matched rows instead of affected rows.

in mysql-odbc control panel Flags1, first option. 😀