Hi!
Using mysql datatables, and sometimes getting "Commands out of sync". How to errorhandle so the tables can be again loaded correct? Closing and open the mysql connection doesent seem to help.
Ole
Command out of sync - errorhandling
Re: Command out of sync - errorhandling
1. The MySqlConnection instance is not guaranteed to be thread safe. You should avoid using the same MySqlConnection in several threads at the same time. It is recommended to open a new connection per thread and to close it when the work is done.
2. Try using the latest (8.3.303) build of dotConnect for MySQL.
If this doesn't help, please localize the issue and send us a small test project with the corresponding DDL/DML script for reproducing.
2. Try using the latest (8.3.303) build of dotConnect for MySQL.
If this doesn't help, please localize the issue and send us a small test project with the corresponding DDL/DML script for reproducing.