Writing large BLOBs throws InvalidOperationException

Writing large BLOBs throws InvalidOperationException

Postby denkhe » Mon 03 Jan 2011 15:37

I am having trouble writing large blobs to a MySQL-Database using the .net entity-framework.
Blobs < 1MB work fine. If I try to write a blob > 1MB a InvalidOperationException with text "Connection must be opened." occurs.

I am using:

1. Visual Studio 2010
2. .Net 3.5
3. Devart ADO.NET Entity Framework (latest)
4. MySSQl (latest)

Help is appreciated.
denkhe
 
Posts: 14
Joined: Mon 03 Jan 2011 15:33

Postby denkhe » Tue 04 Jan 2011 08:01

Update:

Increasing the value of the MySQL-Parameter max_allow_packet actually did the job.
denkhe
 
Posts: 14
Joined: Mon 03 Jan 2011 15:33

Postby AndreyR » Mon 10 Jan 2011 09:50

Thank you for sharing the solution.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for MySQL