odbc Update on a linked table failed

Mysql issues and fixes

Moderator: stephen

odbc Update on a linked table failed

Postby stephen » Tue Nov 25, 2008 9:56 am

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
stephen
 
Posts: 507
Joined: Thu Feb 09, 2006 9:37 am
Location: Brisbane

Return to MYSQL

Who is online

Users browsing this forum: No registered users and 1 guest

cron