| Bug #8329 | Adodc .Update Error | ||
|---|---|---|---|
| Submitted: | 5 Feb 2005 4:54 | Modified: | 5 Feb 2005 16:03 |
| Reporter: | Alfred Ramos | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Connector / ODBC | Severity: | S1 (Critical) |
| Version: | OS: | ||
| Assigned to: | CPU Architecture: | Any | |
[5 Feb 2005 16:03]
Jorge del Conde
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.
If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information
about accessing the source trees is available at
http://www.mysql.com/doc/en/Installing_source_tree.html
Description: I have posted this error for i have seen no absolute (interim solutions worked but a lot of working to do) resolution so far. browsing through the MySQL BUGS to no avail. Suggestions have been tried already and none worked for me. here is my setup: MySQL Ver 4.1.9 MyODBC 3.51.10 / Patch .02 MDAC 2.8 DIM rs as NEW ADODB.Recordset 'First Error at OPTION="" rs("amount")=0 <---- Error Here "Multi-step Operation OLE DB Operation generated errors" 'Made this disappear by using rs.CursorLocation = adUseClient 'but error appear next here.. rs.Update <----- Error Here "Record Cannot be Located for Updating" 'When i changed to OPTION=3 and commented the line rs.CursorLocation =adUseClient rs.Update <------Error Changed to "Query-based update failed because the row to update could not be found" Prior reports with this BUG have beed idle for some months now and i dont know if this have been resolved already, Please keep us updated. How to repeat: conn.Open "Provider=MSDASQL.1;Persist Security Info=False;Extended Properties='DRIVER=MySQL ODBC 3.51 Driver;DATABASE=accounting;OPTION=3;PORT=3306;PWD=supervisor;SERVER=server;UID=root'" rs.Open "SELECT * FROM checktemp", conn, 1, 3 While not RS.eof rs("amount")=0 rs.Update '<---- Error here rs.Movenext Wend