MySQL Set Up

Hi,

I transferred a VB6 application using MySql 3.51 Drver From Windows 98
platform to XP. I downloaded MySql 3.51 set up the ODBC driver connection
(User DSN). The VB6 application runs great however, when I update a record
(.Update) I receive run-time error -2147217864...row cannot be located for
updating etc. What am I doing wrong?

Re: MySQL Set Up

Joel wrote:
> I receive run-time error -2147217864...row cannot be located for
> updating etc. What am I doing wrong?

http://dev.mysql.com/doc/refman/5.0/en/write-conflict.html

"If you see the following errors, select the Return Matching Rows option
in the DSN configuration dialog, or specify OPTION=2, as the connection
parameter:
....
Row cannot be located for updating. Some values may have been changed
since it was last read."

Regards,
Bill K.