[Mono-list] Error Reading from MySQL.
Joe Audette
joe_audette@yahoo.com
Sun, 27 Feb 2005 08:30:46 -0800 (PST)
Hi Jorge,
I have used the TEXT type extensively but not the
LONGTEXT.
The MySQL documentation does have some notes of
relevance though.
From:
http://dev.mysql.com/doc/mysql/en/blob.html
I see
The maximum size of a BLOB or TEXT object is
determined by its type, but the largest value you
actually can transmit between the client and server is
determined by the amount of available memory and the
size of the communications buffers. You can change the
message buffer size by changing the value of the
max_allowed_packet variable, but you must do so for
both the server and your client program. For example,
both mysql and mysqldump allow you to change the
client-side max_allowed_packet value. See Section
7.5.2, “Tuning Server Parameters”, Section 8.3,
“mysql, the Command-Line Tool”, and Section 8.8, “The
mysqldump Database Backup Program”.
I suspect this is related to the problem you are
having. The ByteFx provider may not have the packet
size big enough. You could look at the source for
ByteFx and see what packet size they are using and
maybe adjust it there and/or on the server. Might also
be different using the newer .NET connector for mysql.
Hope it helps,
Joe Audette
--- "Jorge E. Gonzalez" <jgonzalez@optynex.com> wrote:
> I've Web Application, it's working fine but when it
> try to read a field type (LONGTEXT) one erro is
> show.
>
> Error:
> Index and count must refer to a location within the
> buffer. Parameter name: bytes
>
> I'm working whith ByteFX ver 0.76 library
>
> How can I fix this problem o know what's the
> problem?
>
> Thanks
> Jorge Eldis
>
2‰č–+-™¨Ą–+-2‰č–+-–+-ł¦‰©Ü˘hm¶ź˙–+-ł¦‰©Ü˘oćj)fjĺŠËbťú?š‰č–+-
=====
joe_audette@yahoo.com
http://www.joeaudette.com
http://www.mojoportal.com