Lost connection to MYSQL server during query socket error on write.

sc_ups

Lost connection to MYSQL server during query socket error on write. WSAGetLastError return 10054 ($ 2746)
I am inserting a binary file into the database. When the file is about 2MB, there is no problem. Above 3MB, the above problem occurs.
Please advise. Thank you

starfull

Is the field definition not long enough?

sc_ups

I defined file_data longblob like this,
No write length

delraich

Let's take a look at the point source program. It is too unclear to say this, maybe it is not a problem.

sc_ups

MyQuery->SQL->Clear();
        AnsiString str = "select * from TabAttachedFiles";
        MyQuery->SQL->Add(str);
        try
        {
            MyQuery->Open();
        }
        catch(...)
        {
            ;
        }
        MyQuery->Append();
        MyQuery->FieldByName("bugID")->Value = bugID;
        MyQuery->FieldByName("file_name")->Value = ::ExtractFileName(dlg->FileName);
        TBlobField *Field = (TBlobField*)MyQuery->FieldByName("file_data");
        Field->LoadFromFile(dlg->FileName);
        MyQuery->Post();//Not here. It’s okay when the file is small, but not when it’s large
        MyQuery->Close();
I use MyDAC control

forverity

Set up BDE

sc_ups

The problem is solved

freedomsoli

Lost connection to MYSQL server
You are not linked