MySQL Forums
Forum List  »  Delphi

Using ODBC and Delphi for Blob field
Posted by: John Olsen
Date: March 05, 2009 01:25AM

Using the code below with ADO and the ODBC connection to MySQL:

With datamodule1.ADOTable2 do
begin
edit;
TBlobField(FieldByName('Photo')).LoadFromFile('c:\Test.jpg');
//Post;
end;

I get the error message if I post:

[MySQL][ODBC 5.1 Driver][mysql-5.1.30-community]Got a packet bigger than'max_allowed_packet'bytes

Why? Or what is an alternate way to load a file in a blob field from Delphi? Or how do I adjust packet size?

Options: ReplyQuote


Subject
Written By
Posted
Using ODBC and Delphi for Blob field
March 05, 2009 01:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.