Devart Forums

Hi all,

I have installed the Devart dotConnect MySQL Professional drivers v8.1.26 (trial edition) on a Windows 7 x64 workstation, and am working on an SSIS 2012 package. I am running into an issue that I can reproduce with a very simple package:

1. Create a new SSIS project
2. On the Control Flow, add an Execute SQL Task component
3. Set the component to use an ADO.Net connection to a local MySQL 5.6 x64 database using the dotConnect driver. ResultSet is set to None, SQLSourceType is Direct input.
4. In the SQLStatement field, I use the statement "TRUNCATE TABLE model_dim_stage;" (without the quotes).
5. Right click on the task and select Execute.

The task fails with the following error:

[Execute SQL Task] Error: Executing the query "TRUNCATE TABLE model_dim_stage;" failed with the following error: "Malformed communication packet.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

I also have the latest MySQL Connector/Net driver installed. If I change the connection of the task to that driver (but leave everything else untouched) it works. I want to use the dotConnect driver though as the Connector/Net driver has other issues. If I change the SQL statement to a SELECT instead of the TRUNCATE, I get the same situation - the dotConnect driver fails with the same error and the Connector/Net driver works.

Any ideas? Thanks in advance,
Matt

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

Awesome, thanks.

We have fixed the bug with "Malformed communication packet." error when executing a prepared statement on MySQL 5.6.14. We will post here when the corresponding build of dotConnect for MySQL is available for download.

The new build of dotConnect for MySQL 8.1.45 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/mysql/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=28407

Works perfectly now. Thanks for the fix