Stephen, >Hi, > >I have an Access97 table containing binary fields (gifs) that I would like >to migrate to an innodb format via MyODBC (2.50.39) and MySQL-Max (3.23.44). >The MySQL query log shows binary-like characters being received but there >never seems to be progression to the next record. After 5 or so minutes, the >append query in Access97 quits and an ODBC error window complaining about a >lost connection pops-up. When I convert the table to myisam type, the append >query works. Is there something in my.cnf I need to adjust to fix thisproblem?
inserting binary BLOBs should work. What is an 'append' query in MS Access? Is it translated to an INSERT in MySQL? Could you paste a copy of what the MySQL query logs shows? How big is the BLOB? What is the CREATE TABLE statement? Note that a BLOB bigger than > 64 kB needs to be defined a MEDIUMBLOB or LONGBLOB in the CREATE TABLE statement. If you try inserting an ASCII text file does that work? How big you have set max_allowed_packet in my.cnf? That restricts the size of rows communicated from a client to the server. >Thanks, >Stephen Regards, Heikki http://www.innodb.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
