MySQL Connector/ODBC Release Notes
To be able to update a table, you must define a primary key for the table.
Visual Basic with ADO cannot handle big integers. This means
that some queries like SHOW
PROCESSLIST do not work properly. The fix is to
use OPTION=16384 in the ODBC connect
string or to select the Change BIGINT columns to
INT option in the Connector/ODBC connect screen. You may
also want to select the Return matching
rows option.