I'm running VB6 with mySQL and myODBC. The following is occuring. Field1 is defined as varchar(100) default NULL.

'MYSQL CONNECTION
Set cnMySQL = New Connection
cnMySQL.ConnectionString = "Driver={MySQL};Option=0;Port=3306;server=localhost;database=xxxxx;"
cnMySQL.Mode = adModeReadWrite
cnMySQL.CursorLocation = adUseClient
cnMySQL.Open


rs.AddNew
rs("Field1") = "123456789 .." '45 characters works okay

rs("Field1") = "123456789 .." '46 characters fails

'err.number = -2147217887
'err.description = "Multiple-step operation generated errors. Check each status value."
'err.source = "Microsoft Cursor Engine"
'err.helpcontext = 1000440


If I repeat the asignment of the 45 char string again, it will still work even after the 46 char string error.

How do I prevent/handle this?
Thanking you for your time in advance.
John