Command out of sync - errorhandling

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
profixio
Posts: 3
Joined: Wed 10 Dec 2014 10:04

Command out of sync - errorhandling

Post by profixio » Wed 10 Dec 2014 10:10

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

Shalex
Devart Team
Posts: 8088
Joined: Thu 14 Aug 2008 12:44

Re: Command out of sync - errorhandling

Post by 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.

Post Reply