>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

What's the code to open the recordset?