odbc Update on a linked table failed

problem in MS ACCESS with a linked table to MySQL
when tried to add an Excel Sreadsheet into a logblob field
received ODBC errors.
Solution was to edit the /etc/my.cnf file (or my.ini for Windows servers.)
In the section mysqld
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