Well, first of all this belongs in the myODBC thread as the implementation of BLOB fields in mySQL is excellent in my opinion. But to answer your question, you cannot simply put a binary file into a variant type (or any other type) variable and have it get updated. You need to use the ADO stream object. I do not pretend to know what it is doing behind the scenes, but it works quite well in my VB6 front end. The article explaining how the stream object works can be found here: http://support.microsoft.com/default.aspx?scid=kb;[LN];Q258038. One caveat, the default install of mysql allows for files no larger than 1MB, this can be fixed by adjusting the max_allowed_packet variable in my.cnf to a higher number. I use 16M, which is the limit of the mySQL 3.X branch, the 4.x series is limited only by server memory, but if your server is accessed across a WAN, a 16M limit may be a good idea. I found it was for my application.
Good Luck, Mike Hillyer -----Original Message----- From: Bruno Batarelo [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 18, 2002 8:05 AM To: [EMAIL PROTECTED] Subject: BLOB and ADO Greetings There is a persistant problem while trying to insert a string from within VB 6.0 application to the LONGBLOB field. I use ADO and code for adding new record is as followes: TabelaTekst.AddNew TabelaTekst!Polje = BinaryString TabelaTekst.Update and error is: "Multiple-step operation generated errors. Check each status value." I do not know what to do. I use MySQL 4.01 and MyODBC 3.51.03. It occures only with this field data type. I would appreciate any help since I'm in big trouble if I do not solve this. Thank You all. Bruno --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
