MySQL Set Up

21/04/2006, 14h18

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?

21/04/2006, 17h53

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/...-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.

21/04/2006, 14h18	#1
Joel Messages: n/a Hébergeur:	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?

21/04/2006, 17h53	#2
Bill Karwin Messages: n/a Hébergeur:	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/...-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.

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email