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.
Net packets out of order
Re: Net packets out of order
We couldn't reproduce the problem.
Please send us complete small sample to demonstrate it and include script to create server objects.
Please send us complete small sample to demonstrate it and include script to create server objects.
Net packets out of order
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
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
Re: Net packets out of order
Let's try to find out details:
When does this error happen? On retrieving data or passing?
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.
When does this error happen? On retrieving data or passing?
Do you always get just this error message?Net packets out of order: received[2], expected[1]
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.