MySQL Connector/ODBC Developer Guide
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.