Aunty sex video chatting live webcam Row cannot be located for updating mysql server

I only started getting this row update error when I upgraded Mysql from 4.0.23 to 4.1.22 - which tells me the problem must lie with how I have set up Mysql.Hi Everyone I am using VB6 and My SQL, recently installed. I save them, and in a large order (25 or more) there will be at least one which causes an error "Row cannot be located for updating.

I also tried checking "row update" checkbox under the connection it self (under datasources) as others have suggested, but no luck there either.What are some things i can do/check to resolve this issue??Seems this upgrade thing solved that issue as well.This one was simple 🙂 This entry was posted on Sunday, February 6th, 2011 at pm and is filed under Linux-Administration, my server.No other users are accessing the database - only 1 user is accessing the database. Some values may have been changed since it was last read. from Access/MSSQL databases to My SQL and the same code works for both accept My SQL. Tks John Here's a topic in the My SQL docs that addresses this issue: need to enable the "Return Matching Rows" option in My ODBC. Do you know where I can find the documentation for all the options for connection string? The solution is also mentioned on this page about making My SQL & My ODBC work with MS Access: another reference, more complete with screen shots of the proper way to set up the My ODBC DSN for MS Access: Gui...Regards, Bill K. You mentioned MS Access, so I assumed you are still using Access as a front-end to My SQL.

No other users are accessing the database - only 1 user is accessing the database. Tks John "Bill Karwin" Here's a topic in the My SQL docs that addresses this issue: need to enable the "Return Matching Rows" option in My ODBC. I've tried below and none works - I am using My ODBC to access My SQL not MS Access. I tried change OPTION=2 as suggested in still get the same error.

When I try to update record, I kept getting this error: Row cannot be located for updating.

Some values may have been changed since it was last read. from Access/MSSQL databases to My SQL and the same code works for both accept My SQL. Tks John When I try to update record, I kept getting this error: Row cannot be located for updating. The solution is also mentioned on this page about making My SQL & My ODBC work with MS Access: another reference, more complete with screen shots of the proper way to set up the My ODBC DSN for MS Access: Gui...Regards, Bill K. I've tried below and none works - I am using My ODBC to access My SQL not MS Access. I tried change OPTION=2 as suggested in still get the same error.

In other words, are you including the primary key field in the query, and are not doing any aggregates (GROUP BY), or other types of queries that would make it non-updateable? It is definitely updateable as this happens on 2 out of 3 records only (of the same record) - this is the strange part.

Do you know where I can find the documentation for all the options for connection string? The exact same codes works with MS Access and MS SQL databases.

You can follow any responses to this entry through the RSS 2.0 feed.