odbc Update on a linked table failed

[stephen]

problem in MS ACCESS with a linked table to MySQL
when tried to add an Excel Sreadsheet into a logblob field
received ODBC errors.

Got a packet bigger than 'max_allowed_packet'

Solution was to edit the /etc/my.cnf file (or my.ini for Windows servers.)
In the section mysqld

Code: Select all

[mysqld]
set-variable = max_allowed_packet=32M