Page 1 of 1

odbc Update on a linked table failed

PostPosted: Tue Nov 25, 2008 9:56 am
by 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