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
Posted by at
Labels: , ,

80 comments:

  1. SamAugust 26, 2008 at 7:44 PM

    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. MarvinAugust 31, 2008 at 11:42 PM

    Hey, Reggie,

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

    Thanks!

    ReplyDelete
  3. reggieSeptember 1, 2008 at 9:04 PM

    I've fixed this in 5.2.4

    ReplyDelete
  4. Amre EllafiSeptember 5, 2008 at 6:50 PM

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

    ReplyDelete
  5. DarlSeptember 7, 2008 at 3:09 PM

    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. Busby SEO TestJanuary 2, 2009 at 1:13 PM

    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. Organic Skin CareJanuary 12, 2009 at 2:21 AM

    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. RichardJanuary 13, 2009 at 5:01 PM

    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. Icon EnergyJanuary 14, 2009 at 2:42 AM

    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. busby seo test caseJanuary 16, 2009 at 7:37 PM

    another great news..

    ReplyDelete
  15. busby seo test postJanuary 19, 2009 at 12:08 PM

    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. YohimbeJanuary 21, 2009 at 3:10 AM

    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. Christian AnswersJanuary 23, 2009 at 8:37 PM

    Nice post.

    ReplyDelete
  21. Raleigh MoversMarch 15, 2009 at 12:51 AM

    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. Cirurgia PlasticaMarch 19, 2009 at 7:25 PM

    when we can expect version 5.2.4 out ?

    ReplyDelete
  24. betclicApril 6, 2009 at 6:11 PM

    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. cctv monitorApril 27, 2009 at 6:19 PM

    Where can i have more info on this ?

    Regards

    Pari

    ReplyDelete
  30. bipsApril 29, 2009 at 4:20 PM

    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. Essay WritingMay 18, 2009 at 7:08 PM

    Excellent tutorial about SQL

    ReplyDelete
  37. DissertationMay 18, 2009 at 7:10 PM

    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. Gucci BagMay 27, 2009 at 9:31 PM

    I needed this info thanks mate

    Regards
    Huio

    ReplyDelete
  42. Earn MoneyJune 1, 2009 at 12:53 AM

    Thanks for letting know, will check it out!

    ReplyDelete
  43. aste al ribassoJune 1, 2009 at 11:57 AM

    I bookmarked this already dude great work

    Regards
    K.P Sanu

    ReplyDelete
  44. tukang nggameJune 4, 2009 at 1:30 AM

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

    ReplyDelete
  45. Toronto hotelsJune 4, 2009 at 6:01 PM

    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. free musicJune 5, 2009 at 3:03 PM

    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. atlanta moversJune 7, 2009 at 12:22 AM

    I donno what to do

    ReplyDelete
  49. israel electionsJune 7, 2009 at 12:22 AM

    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. tiffanyJune 13, 2009 at 2:16 PM

    good!

    ReplyDelete
  52. knockoff handbagsJune 15, 2009 at 4:13 PM

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

    ReplyDelete
  53. Tiffany jewelryJune 17, 2009 at 8:37 AM

    I am gree with you!

    ReplyDelete
  54. jackmilneyJune 18, 2009 at 10:38 AM

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


    Gabs

    ReplyDelete
  55. jackmilneyJune 18, 2009 at 10:39 AM

    I bookmarked this already dude great work

    Regards


    Anu

    ReplyDelete
  56. jackmilneyJune 18, 2009 at 10:39 AM

    Hiiiiiiiiiiiii...........


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

    Thanks.

    ReplyDelete
  57. jackmilneyJune 18, 2009 at 10:39 AM

    Thanks for letting know, will check it out!

    Thanks.

    ReplyDelete
  58. tiffany jewellryJune 18, 2009 at 10:58 AM

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

    ReplyDelete
  59. club penguinJune 18, 2009 at 3:24 PM

    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
  60. tiffany jewelleryJune 20, 2009 at 1:47 PM

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

    ReplyDelete
  61. tiffany ringsJune 21, 2009 at 6:52 AM

    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. Tiffany EarringsJune 21, 2009 at 2:37 PM

    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
  63. my blogging netJune 25, 2009 at 8:35 AM

    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
  64. tiffany ringsJune 28, 2009 at 7:48 AM

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

    ReplyDelete
  65. hostwaffle09June 28, 2009 at 7:08 PM

    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
  66. tiffanyJuly 1, 2009 at 8:07 AM

    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
  67. linksoflondonJuly 2, 2009 at 6:41 AM

    Thanks for such a nice post.

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

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

    ReplyDelete
  69. classic tiffanyJuly 5, 2009 at 6:41 AM

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

    ReplyDelete
  70. Billy DJuly 11, 2009 at 12:39 AM

    Cool blog, just bookmarked it for later reference

    ReplyDelete
  71. Marc EckoJuly 13, 2009 at 8:53 PM

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

    ReplyDelete
  72. TravelmaniakJuly 15, 2009 at 3:25 AM

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

    ReplyDelete
  73. Lån PengeJuly 17, 2009 at 7:33 PM

    Cool post - thanks a lot m8!

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

    Thank you, for this code :) Cheers!

    ReplyDelete
  75. anxiety curesJuly 20, 2009 at 2:13 AM

    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
  76. HoodiaJuly 22, 2009 at 10:51 AM

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

    ReplyDelete
  77. 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
  78. 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
  79. 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
  80. Facebook FansDecember 17, 2011 at 11:59 AM

    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

Subscribe to: Post Comments (Atom)