Devart Forums

Hello!

Again we've some problems with your lib. Inserting of binary data results in

- "Net packets out of order: received[2], expected[3]" exceptions on an intranet server

or in

- "Lost connection to MySQL server during query" exceptions on a local server

It helps to close and open the connection with EVERY record (we use parameters) - That can not be the real solution for this problem... Also the non-direct mode (libmysql) is a solution. The max_allowed_packets is high enough, we use a 5.0 server and all other tools work with this binary files.

We are a little bit displeased with your software. It's slower than the original connector and there are to many bugs, when you are a heavy user of the lib. I hope you can quickly find a solution for this...

Regards,

Sven Kolber

"Net packets out of order: received[2], expected[3]" exceptions on an intranet server

1. Do you use Prepare method or non-direct mode (Direct=false)?
2. Make sure you close all data readers explicitly.
3. If you use Prepare() method of MySqlCommand class, call Dispose() after closing reader.
4. If you use connection pooling, call MySqlConnection.Ping() method before MySqlConnection.Open().
5. If above doesn't help and you use connection pooling, check if you can turn connection pooling off.

Please inform us whether our instructions helped you and which one solved the problem.

We are a little bit displeased with your software. It's slower than the original connector

According to our performance tests results, MySQLDirect .NET is no worse than Connector/NET provider by MySQL AB.
If you have an example of dramatic difference in speed, please send it to the address provided in the Readme file.

there are too many bugs

Describe in detail all the bugs you are complaining about.