Page 1 of 1

Command out of sync - errorhandling

Posted: Wed 10 Dec 2014 10:10
by profixio
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

Re: Command out of sync - errorhandling

Posted: Wed 10 Dec 2014 17:42
by Shalex
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.