Thursday, March 22, 2007

MySQL Connector/Net 5.0.6 has been released.

MySQL Connector/Net 5.0.6 a new version of the all-managed .NET driver for MySQL has been released.
This is a bug fix release for the current production branch of Connector/Net.

 
Version 5.0.6 is suitable for use with any MySQL version including MySQL-4.1, MySQL-5.0, MySQL-5.1 beta or the MySQL-5.2 Falcon "Preview".
It is now available in source and binary form from the Connector/Net download pages at http://dev.mysql.com/downloads/connector/net/5.0.html and mirror sites (note that not all mirror sites may be up to date at this point of time - if you can't find this version on some mirror, please try again later or choose another download site.)

 
This release comes shortly after 5.0.5 due to an incompatibility with Tools for Visual Studio.  With 5.0.5, we changed how the connector respects binary data as reported by the server.  This resulted in some queries that now return data as byte arrays that before returned data as string. Unfortunately this is still the case with 5.0.6.  Current versions of MySQL incorrectly return some metadata as binary.  Queries such as 'SHOW CREATE TABLE' will often return data as binary.  You can work around this by using a MySqlDataReader and reading the desired columns using .GetString().

Functionality Changes or Enhancements
No functionality changes to report.

Bugs fixed:
Bug #27135 MySqlParameterCollection and parameters added with Insert Method
Bug #27253 Installer : Company info is different
Bug #27187 cmd.Parameters.RemoveAt("Id") will cause an error if the last item is requested
Bug #27093 Exception when using large values in IN UInt64 parameters
Bug #27221 describe SQL command returns all byte array on MySQL versions older than 4.1.15
Bug #26960 Connector .NET 5.0.5 / Visual Studio Plugin 1.1.2

As always we thank you for your use of our products and keep those bug reports coming!

2 comments:

  1. hi reggie -

    just came across this site in search of a fix for a problem I'm having with the new mysql.data.dll for vs2005. two days ago I purchased a new machine and loaded vs2005 on it and converted my previous project, which was built in vs2003. I quickly realized I had to get a new mysql.data.dll for 2.0, so I downloaded and implemented it. luckily, everything has gone smoothly for the customer side of the site. However, I have some queries on the backend that aren't functioning correctly anymore where they used to work fine. For instance, I have a dropdown menu that used to display a list of products for me to choose from, and it would display them in the format "[productid] | [productname]" where "productid" is an integer in my mysql database and "productname" is text. The actual query is:

    SELECT productid AS TheValue, CONCAT(productid, ' | ', name) AS TheText FROM tblProducts ORDER BY TheValue

    when I bind this to my dropdown menu, i receive a bunch of "System.Byte[]"s in place of "TheText". TheValue returns correctly. I experimented with this problem a bit and discovered that if I removed the "productid" from the CONCAT statement, everything returned as it should, minus, of course, the productid, which I need. This query returns the correct response when entered directly into the database (phpmydamin). Apparently the mysql connector will not allow mixed types to be concatenated, for reasons unbeknownst to me.

    Do you have a solution for this? If so, I would be *much* obliged. Please email me if you can. Thanks!

    Jason

    ReplyDelete
  2. Jason

    Did you find a fix for your system.bye[] problem?

    Regards

    Jason.

    ReplyDelete