BLOB Update failing on SQLParamData

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!


trying to update a BLOB column using SQLParamData / SQLPutData and it all
works fine until the BLOB is > ~700KB.  I'm putting it in 1KB chunks, but I
have also tried 2KB without success.  The SQLPutdata succeeds, but when the
final SQLParamData is called SQL_ERROR is returned and the log file shows:

DIAG [S1000] [MySQL][ODBC 3.51 Driver][mysqld-4.1.8-standard]Lost connection
to MySQL server during query (2013)

my.cnf cantains the following:

set-variable = key_buffer_size=16M
set-variable = max_allowed_packet=1M

I'm stumped, an suggestions gratefully received.

Site Timeline