Hi.

I migrated my fully working Access website to MySQL but now my row updates do not work, instead returning

"Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Query-based update failed because the row to update could not be found.

/test.asp, line 73"


I converted the database using MDBtoMySQL XP which worked fine (although it changed some bools to <name>_1 tinyints for some reason.)

Im connecting over DNS (using access i was using DNS less) and have set up My SQL Server v 4.0.2 and My SQL ODBC 3.51 driver.

SQL reads work fine, its just when i try to do an .update AFTER reading some data from the SQL select i get Query-based update failed because the row to update could not be found. which is crazy because ive just read and can output valid data from the row! this happens various pages on all tables where i try to do an .update after SELECT. the same code worked under Access!

Thanks

Example Code:

r.open "SELECT * FROM tbl_Messages WHERE id = '" & 65628 & "'",conn,,2
response.write r("message") << writes out a valid message
r("message") = "hello"
response.write r("message") << writes out "hello"
r.update << causes "Query-based update failed because the row to update could not be found."
r.close