Command out of sync - errorhandling

Command out of sync - errorhandling

Postby profixio » Wed 10 Dec 2014 10:10

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.
Posts: 2
Joined: Wed 10 Dec 2014 10:04

Re: Command out of sync - errorhandling

Postby Shalex » Wed 10 Dec 2014 17:42

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.
Devart Team
Posts: 7460
Joined: Thu 14 Aug 2008 12:44

Return to dotConnect for MySQL