Monday, August 18, 2008

Connector/Net 5.2.3 GA has been released

MySQL Connector/Net 5.2.3, a new version of the all-managed .NET driver for MySQL has been released.  This release is of GA quality and is suitable for  use in production environments.  We strongly urge you to  review the change log that is shipped with the product for a thorough review of the changes.

Version 5.2.3 works with all versions of MySQL including MySQL-4.1,  MySQL-5.0, MySQL-5.1 beta or the MySQL-6.0 Falcon "Preview".

It is now available in source and binary form from [http://dev.mysql.com/downloads/connector/net/5.2.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.)

Changes since 5.2.2

  • Increased the speed of MySqlDataReader.GetOrdinal dramatically by using a couple of hashes for lookups
  • Fixed problem where some tables that support the web providers used the latin1 character set instead of the database default.  (bug #36444)
  • Changed how the procedure schema collection is retrieved.  If 'use procedure bodies=true' then we select on the mysql.proc table directly as this is up to 50x faster than our current IS implementation.  If 'use procedure bodies=false', then the IS collection is queried.  (bug #36694)
  • Fixed problem with our GetOrdinal speedup where we would attempt to add an already existing key to a hash when a resultset had more than 1 column with the same name. (bug #37239)
  • small fix to how we were allowing in/out and out parameters to slide through parameter serialization.  Before we were setting the AllowUserVariables connection setting but that had the unfortunate side effect of setting the value for all connections that shared that connection string.  This way we isolate it just to our particular command.  This may fix bug #37104
  • Fixed documentation surrounding use of ? vs @ for parameters (bug #37349)
  • Reduced network traffic for the normal case where the web provider schema is up to date (bug #37469)
  • Improved error reporting when a timeout occurs.  It no longer uses a message like 'reading from stream failed'.  (bug #38119)
  • fixed problem where adding a non-existent user to a role would not auto-create the user record (bug #38243)
  • moved string escaping routine from the MySqlString class to the MySqlHelper class and made it public and static.  (bug #36205)
  • Fixed problem where column metadata was not being read with the correct character set  (bug #38721)
  • Fixed problem where the uninstall was not cleaning up the state files (bug #38534)
  • Added 'Functions Return String' connection string option
  • Several other fixes merged in from 5.0 and 5.1

80 comments:

  1. Reggie,

    I kept getting to following error when attempting to use the 5.2.3 Membership and Role providers in my ASP.Net 2.0 app:
    Unable to initialize provider. Missing or incorrect schema. (D:\Web\FinderNew\web.config line 52)

    I had included autogenerateschema="true" on all of my providers, but it did not seem to want to generate the schema. Couldn't get it to work with the providers installed, or by including them in the Bin directory.

    I ended up downloading the source code version and merging the 4 SQL files into one and creating the tables manually (through MySQL Browser). It works now.

    Finally, may I recommend adding the MySql.Web dll and the composite SQL script to the binaries zip?

    ReplyDelete
  2. Hey, Reggie,

    I am having the same trouble that Sam reports. I am going to try his solution.

    Thanks!

    ReplyDelete
  3. I've fixed this in 5.2.4

    ReplyDelete
  4. reggie , thanks for fixing the issue ,when we can expect version 5.2.4 out ?

    ReplyDelete
  5. Hi Reggie,

    Am getting an "Exception: Profile update failed"

    Using the ProfileProvider the stack trace is below

    [quote]
    [Exception: Profile update failed.]
    MySql.Web.Profile.MySQLProfileProvider.SetPropertyValues(SettingsContext context, SettingsPropertyValueCollection collection) +619

    [ProviderException: Profile update failed.]
    MySql.Web.Profile.MySQLProfileProvider.SetPropertyValues(SettingsContext context, SettingsPropertyValueCollection collection) +731
    System.Configuration.SettingsBase.SaveCore() +379
    System.Configuration.SettingsBase.Save() +77
    System.Web.Profile.ProfileBase.SaveWithAssert() +31
    System.Web.Profile.ProfileBase.Save() +63
    System.Web.Profile.ProfileModule.OnLeave(Object source, EventArgs eventArgs) +2397611
    System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
    System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
    [\quote]

    Below is the profile section of my web.config

    [quote]
    <sessionState mode="Off"/>
    <anonymousIdentification enabled="true"
    cookieName=".ASPXANONYMOUS"
    cookiePath="/"
    cookieRequireSSL="false"
    cookieSlidingExpiration="true"
    cookieProtection="All"
    cookieless="UseCookies"/>
    <profile defaultProvider="MySQLProfileProvider" enabled="true" >
    <providers>
    <clear/>
    <add connectionStringName="FRCN"
    name="MySQLProfileProvider"
    type="MySql.Web.Profile.MySQLProfileProvider"
    applicationName="/"/>
    </providers>
    <properties>
    <add name="FullName" type="System.String" serializeAs="Xml" allowAnonymous="false" provider="MySQLProfileProvider"/>
    </properties>
    </profile>
    [\quote]

    Am actually trying to implement a shopping cart, at first I supected my shopping cart type, but after removing the type from the profile and left just only the FullName property am still getting the same error.

    ReplyDelete
  6. Great thing for this code Connector/Net 5.2.3 GA has been released.

    ReplyDelete
  7. busby seo test blog tipsJanuary 9, 2009 at 6:14 AM

    Great tips for fixing the Blogengine.NET realese. Many users are glad to see this

    ReplyDelete
  8. reggie , thanks for fixing the issue ,when we can expect version coming out ?

    ReplyDelete
  9. Online Merchant AccountJanuary 13, 2009 at 3:07 AM

    Hey reg. Great post and boy I just wanted to say that I wouldn't know what to do if mySql was never greated.

    ReplyDelete
  10. I initially had some MySQL problems when I tried to set up a way to <a href="www.cardaccept.com">accept online payments</a> from my website. Reading your blog helped answer a few of the questions I had and helped me get things sorted out. Thankfully everything is working properly now and I have a bit more knowledge concerning MySQL than I did previously.

    Thank you.

    ReplyDelete
  11. Great article on the codes. Good job. Keep up the great work.

    ReplyDelete
  12. alcohol hangover headache cureJanuary 16, 2009 at 2:29 AM

    "Like i said in my prevoius post am doing a shopping cart, all the line commented is because I have removed the wishlist and shopping cart from the profile properties and just added the fullname property to be sure the error is not due to my cart and wishlist type. "

    Good call...this will help weed out problems and help with smoother procedure.

    ReplyDelete
  13. Google Dance for Busby SEO Test in this Chinese New Year 2009January 16, 2009 at 5:31 AM

    Thanks for this info.. and really cool codes... thanks

    ReplyDelete
  14. another great news..

    ReplyDelete
  15. what a great info. thanks!

    ReplyDelete
  16. revitol stretch mark creamJanuary 20, 2009 at 11:19 AM

    This is good stuff for noobs like me. There are still some parts I don't understand though.

    ReplyDelete
  17. direct travel insurance dealsJanuary 20, 2009 at 11:22 AM

    I run a travel site so this new development will be useful and hopefully make the buying online insurance experience smoother for customers.

    ReplyDelete
  18. Very entertaining site. I've bookmarked your site and added you on my blogroll! Keep up the great work.

    ReplyDelete
  19. how to make fast moneyJanuary 23, 2009 at 6:18 AM

    This looks like a great upgrade. I've downloaded it to try it out.

    ReplyDelete
  20. Nice post.

    ReplyDelete
  21. Great article on the codes. Good job. Keep up the great work.

    ReplyDelete
  22. Real Estate in CaesareaMarch 15, 2009 at 12:53 AM

    Hey, Reggie,

    I am having the same trouble that Sam reports. I am going to try his solution.

    Thanks!

    ReplyDelete
  23. when we can expect version 5.2.4 out ?

    ReplyDelete
  24. Thanks for that usefull post ! it permit me to fix my problem ! Thanks a lot Dude !
    I put your website in my bookmark ! so helpfull !

    ReplyDelete
  25. internet lead generationApril 22, 2009 at 1:59 PM

    Nice Read

    Regards
    bani

    ReplyDelete
  26. how to lower blood sugarApril 22, 2009 at 3:49 PM

    Great Work !

    Regards

    paul

    ReplyDelete
  27. order error nuker softwareApril 25, 2009 at 1:00 PM

    Great article as always Raggie!
    Your fellow reader Matty

    ReplyDelete
  28. Medical Answering ServicesApril 27, 2009 at 12:53 AM

    Nice Read

    Regards

    Bete

    ReplyDelete
  29. Where can i have more info on this ?

    Regards

    Pari

    ReplyDelete
  30. Nice Read

    Regards
    free mp3

    ReplyDelete
  31. Medical alarm systemsMay 4, 2009 at 1:38 PM

    Thanks for such a nice post.

    Regards
    Iqoin

    ReplyDelete
  32. Wedding Boston MAMay 11, 2009 at 3:55 PM

    Can i have more info on this ?

    Regards

    Dramae

    ReplyDelete
  33. architecture firms laMay 14, 2009 at 4:14 PM

    I got your blog from google.com i am doing a thesis on this niche can i have more info ?

    Regards
    Capton

    ReplyDelete
  34. Field Hockey ScholarshipMay 15, 2009 at 11:31 AM

    Great Work !

    Regards
    Gouri

    ReplyDelete
  35. shugo chara doki 85May 18, 2009 at 3:15 PM

    hii
    nice good post
    Regards
    rocky

    ReplyDelete
  36. Excellent tutorial about SQL

    ReplyDelete
  37. I kept getting to following error when attempting to use the 5.2.3 Membership and Role providers in my ASP.Net 2.0 app:

    ReplyDelete
  38. cleaning franchisesMay 21, 2009 at 4:01 PM

    Hey - nice blog, just looking around some blogengine.net sites, seems a pretty nice platform. I'm currently using Wordpress for a few of my sites but looking to change one of them over to blogengine.net as a trial run. Anything in particular you would recommend about it? Cheers, Matthew

    ReplyDelete
  39. affordable SEO companiesMay 24, 2009 at 6:51 PM

    Im very glad you made some updates, good job

    ReplyDelete
  40. child adoption informationMay 27, 2009 at 2:07 PM

    Where can i have more info on this ?

    Regards

    Harry

    ReplyDelete
  41. I needed this info thanks mate

    Regards
    Huio

    ReplyDelete
  42. Thanks for letting know, will check it out!

    ReplyDelete
  43. I bookmarked this already dude great work

    Regards
    K.P Sanu

    ReplyDelete
  44. i'm a very lucky find this blog, hopefully can learn more from this blog

    ReplyDelete
  45. Good post.I'm currently using Wordpress for a few of my sites but looking to change one of them over to blogengine.

    ReplyDelete
  46. I really feel happy to have this blog.This really put me in a good state.I had an awesome sharing.
    Thanks,

    ReplyDelete
  47. Philadelphia moversJune 7, 2009 at 12:22 AM

    cant be nicer then u r

    ReplyDelete
  48. I donno what to do

    ReplyDelete
  49. i can make it better

    ReplyDelete
  50. open source call center VancouverJune 9, 2009 at 1:22 PM

    This shows me the better way for it.

    ReplyDelete
  51. review the change log that is shipped with the product for a thorough review of the changes.

    ReplyDelete
  52. I am gree with you!

    ReplyDelete
  53. Great article on the codes. Good job. Keep up the great work.


    Gabs

    ReplyDelete
  54. I bookmarked this already dude great work

    Regards


    Anu

    ReplyDelete
  55. Hiiiiiiiiiiiii...........


    i'm a very lucky find this blog, hopefully can learn more from this blog

    Thanks.

    ReplyDelete
  56. Thanks for letting know, will check it out!

    Thanks.

    ReplyDelete
  57. thank you for giving us a comment place.
    i support your idea.hope you everying goes well.

    ReplyDelete
  58. I had included autogenerateschema="true" on all of my providers, but it did not seem to want to generate the schema. Couldn't get it to work with the providers installed, or by including them in the Bin directory.

    ReplyDelete
  59. I apppraciate your comment ,your idea is wonderful.
    wish you everything goes smoothly !

    ReplyDelete
  60. Thanks for the great widget! Going to add it to my installation next week.
    I've also posted about it on the BlogEngine Forums

    ReplyDelete
  61. Thanks for the great widget! Going to add it to my installation next week.
    I've also posted about it on the BlogEngine Forums

    ReplyDelete
  62. I want to have additional information using HTML, Java, CSS for my blog site. And finding what themes are applicable to my blog site and choosing what is the best version of blogengine for my blog site.

    ReplyDelete
  63. Thanks for writing this truely cracking blog post, I enjoyed reading it

    ReplyDelete
  64. Hello friends.


    Nice blog, just looking around some blogengine.net sites, seems a pretty nice platform.
    I apppraciate your comment ,your idea is wonderful.
    wish you everything goes smoothly !

    Thanks.

    James


    http://www.hostwaffle.com/

    ReplyDelete
  65. It was a very nice idea! Just wanna say thank you for the information you have shared. Just continue writing this kind of post. I will be your loyal reader. Thanks again.

    ReplyDelete
  66. Thanks for such a nice post.

    ReplyDelete
  67. hkdedicatedhostingJuly 2, 2009 at 10:01 AM

    thanks for sharing
    i like it
    it is very useful
    thanks again

    ReplyDelete
  68. Thanks for writing this truely cracking blog post, I enjoyed reading it

    ReplyDelete
  69. Cool blog, just bookmarked it for later reference

    ReplyDelete
  70. Hey I love your style I will subscribe for your feed please keep posting!

    ReplyDelete
  71. Thats intresting, thanks for sharing. I'm sure others will see things the same way

    ReplyDelete
  72. Cool post - thanks a lot m8!

    ReplyDelete
  73. запознанстваJuly 19, 2009 at 2:36 AM

    Thank you, for this code :) Cheers!

    ReplyDelete
  74. Hello people, I have a skimpy problem... I u are running blogengine from ms. I'm using an anxiety and panic disorder blog on wordpress and i am willing to switch. Does it only run on microsoft server?? Thanks, Debra Trotter

    ReplyDelete
  75. Thanks.. Funny, I actually had this on my mind a few days ago..

    ReplyDelete
  76. North Raleigh NeighborhoodsJuly 23, 2009 at 12:46 AM

    Well this is a nicely explained article on the new features and fixes incorporated with the new MySQL Connector/Net 5.2.3. Thanks for this essential information.

    ReplyDelete
  77. panic disorder agoraphobiaSeptember 5, 2009 at 8:33 PM

    good day, you have a nice blog! I have a little something to add: when you suffer from an agoraphobia attack, you need to look for proven cures rather than looking for untested panic disorder agoraphobia treatment cures

    ReplyDelete
  78. agoraphobia treatmentSeptember 5, 2009 at 8:33 PM

    hello, you have a nice blog! I have a little something to add: when you suffer from an agoraphobia attack, you need to look for tried-and-tested treatments instead of looking for newly discovered panic disorder agoraphobia treatment cures

    ReplyDelete
  79. Extra Reading...

    [...]we like to honor other sites on the web, even if they aren't related to us, by linking to them. Below are some sites worth checking out[...]...

    ReplyDelete