Devart Forums

I'm using MySQL 4.1.7 and I tested dbExpress 2.10
After a few queries , run succesfully I got the errors like that:
Net packets out of order: received[2], expected[1]

what should be the problem here ?

when I'm using the MyDAC component all seems works well.

We couldn't reproduce the problem.
Please send us complete small sample to demonstrate it and include script to create server objects.

I'm sorry but I could not be able to reproduce the problem in a small project.
I get the problem only on a big project wich previoudly run on mysql 4.0.
and started with problem like 'loosing connection' just after the upgrade to revision 4.1.
So I suspect that there something wrong in the windows environment.

I tried your dbexpress version because it didn't require libmysql.dll and I hope this should help.
Using your version of dbexpress I got what I think a disconnection.
If I enquire the SQLConnection->Connected state it is active but if try to use it I got the error 'Net packets out of order....'
If I close and reopen the connection of SQLConnection as
SQLConnection->Connected = false;
SQLConnection->Connected = true;
the program can read and write to database for a while , then the problem reappear.

regards

Let's try to find out details:

When does this error happen? On retrieving data or passing?

Net packets out of order: received[2], expected[1]

Do you always get just this error message?

Please specify if you update MySQL Server and DbxMda at the same time. If so, please advise whether you have this error if use the old version of the driver.