MySQL - ODBC - VB6 (ADODB)

[Radovan Vrbsky]

Hi everyone, I have the following problem:

I'm trying to store string value (20 chars) into a varchar field and I'm allways getting Run-time error '-2147217887 (80040e21)'. Code is in MS Visual Basic 6.0, I'm using ADODB and database connection thru ODBC.

The varchar field size is defined longer then inserted string value.
I tried to resize varchar field to much bigger size (50, 100, ...).
I tried to use the charset utf-8, cp1250, ascii.
I tried to use variable or fixed length row format.
I changed the table type to MyISAM or to InnoDB.

I found only one dependecy:
If I change another row in this table by different way (MySQL Query Browser) and put some long string to this string field, then the code in VB works without errors.
When I remove the long string, the runtime error appears.

Situation:
OS Windows 2000 Professional SP 4
MySQL 4.1.9
MySQL ODBC 3.51.10-2
MS Visual Basic 6.0 SP 6
ADODB 2.6

Is here anyone, who can help me with this basic database functionality?
Thanks a lot!

Radovan Vrbsky