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

This entry was posted by reggie on August 18, 2008 at 4:50 pm, and is filed under .NET, MySQL, Technology. Follow any responses to this post through RSS 2.0.Responses are currently closed, but you can trackback from your own site.

Comments (81)
Related Posts

#1 written by Sam 3 years ago

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:WebFinderNewweb.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?
#2 written by Marvin 3 years ago

Hey, Reggie,

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

Thanks!
#3 written by reggie 3 years ago

I’ve fixed this in 5.2.4
#4 written by Amre Ellafi 3 years ago

reggie , thanks for fixing the issue ,when we can expect version 5.2.4 out ?
#5 written by Darl 3 years ago

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.
#6 written by Darl 3 years ago

public partial class ShoppingCart : System.Web.UI.Page
{
protected void Page_Load( object sender, EventArgs e )
{
if( !IsPostBack )
{
string itemId = Request.QueryString[ "addItem" ];
if( !string.IsNullOrEmpty( itemId ) )
{
//Product pro = Products.GetProduct( itemId );

//CartItem item = new CartItem( pro.ProductGUID, pro.ProductName, 1, pro.OurPrice );

//Dummy just to test error reoccuring
Profile.FullName = "Webmaster";

//Profile.ShoppingCart.Add( item );
//Profile.WishList.Add( item );

// Redirect to prevent duplictations in the cart if user hits "Refresh"
Response.Redirect( "~/ShoppingCart.aspx", true );
}
}
}

protected void Page_PreInit( object sender, EventArgs e )
{

}
}

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.
#7 written by Busby SEO Test 3 years ago

Great thing for this code Connector/Net 5.2.3 GA has been released.
#8 written by busby seo test blog tips 3 years ago

Great tips for fixing the Blogengine.NET realese. Many users are glad to see this
#9 written by Organic Skin Care 3 years ago

reggie , thanks for fixing the issue ,when we can expect version coming out ?
#10 written by Online Merchant Account 3 years ago

Hey reg. Great post and boy I just wanted to say that I wouldn’t know what to do if mySql was never greated.
#11 written by Richard 3 years ago

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.
#12 written by Icon Energy 3 years ago

Great article on the codes. Good job. Keep up the great work.
#13 written by alcohol hangover headache cure 3 years ago

"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.
#14 written by Google Dance for Busby SEO Test in this Chinese New Year 2009 3 years ago

Thanks for this info.. and really cool codes… thanks
#15 written by busby seo test case 3 years ago

another great news..
#16 written by busby seo test post 3 years ago

what a great info. thanks!
#17 written by revitol stretch mark cream 3 years ago

This is good stuff for noobs like me. There are still some parts I don’t understand though.
#18 written by direct travel insurance deals 3 years ago

I run a travel site so this new development will be useful and hopefully make the buying online insurance experience smoother for customers.
#19 written by Yohimbe 3 years ago

Very entertaining site. I’ve bookmarked your site and added you on my blogroll! Keep up the great work.
#20 written by how to make fast money 3 years ago

This looks like a great upgrade. I’ve downloaded it to try it out.
#21 written by Christian Answers 3 years ago

Nice post.
#22 written by Raleigh Movers 3 years ago

Great article on the codes. Good job. Keep up the great work.
#23 written by Real Estate in Caesarea 3 years ago

Hey, Reggie,

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

Thanks!
#24 written by Cirurgia Plastica 3 years ago

when we can expect version 5.2.4 out ?
#25 written by betclic 3 years ago

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 !
#26 written by internet lead generation 3 years ago

Nice Read

Regards
bani
#27 written by how to lower blood sugar 3 years ago

Great Work !

Regards

paul
#28 written by order error nuker software 3 years ago

Great article as always Raggie!
Your fellow reader Matty
#29 written by Medical Answering Services 3 years ago

Nice Read

Regards

Bete
#30 written by cctv monitor 3 years ago

Where can i have more info on this ?

Regards

Pari
#31 written by bips 3 years ago

Nice Read

Regards
free mp3
#32 written by Medical alarm systems 3 years ago

Thanks for such a nice post.

Regards
Iqoin
#33 written by Wedding Boston MA 3 years ago

Can i have more info on this ?

Regards

Dramae
#34 written by architecture firms la 3 years ago

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

Regards
Capton
#35 written by Field Hockey Scholarship 3 years ago

Great Work !

Regards
Gouri
#36 written by shugo chara doki 85 3 years ago

hii
nice good post
Regards
rocky
#37 written by Essay Writing 3 years ago

Excellent tutorial about SQL
#38 written by Dissertation 3 years ago

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:
#39 written by cleaning franchises 2 years ago

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
#40 written by affordable SEO companies 2 years ago

Im very glad you made some updates, good job
#41 written by child adoption information 2 years ago

Where can i have more info on this ?

Regards

Harry
#42 written by Gucci Bag 2 years ago

I needed this info thanks mate

Regards
Huio
#43 written by Earn Money 2 years ago

Thanks for letting know, will check it out!
#44 written by aste al ribasso 2 years ago

I bookmarked this already dude great work

Regards
K.P Sanu
#45 written by tukang nggame 2 years ago

i’m a very lucky find this blog, hopefully can learn more from this blog
#46 written by Toronto hotels 2 years ago

Good post.I’m currently using WordPress for a few of my sites but looking to change one of them over to blogengine.
#47 written by free music 2 years ago

I really feel happy to have this blog.This really put me in a good state.I had an awesome sharing.
Thanks,
#48 written by israel elections 2 years ago

i can make it better
#49 written by atlanta movers 2 years ago

I donno what to do
#50 written by Philadelphia movers 2 years ago

cant be nicer then u r
#51 written by open source call center Vancouver 2 years ago

This shows me the better way for it.
#52 written by tiffany 2 years ago

good!
#53 written by knockoff handbags 2 years ago

review the change log that is shipped with the product for a thorough review of the changes.
#54 written by Tiffany jewelry 2 years ago

I am gree with you!
#55 written by jackmilney 2 years ago

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

Gabs
#56 written by jackmilney 2 years ago

Thanks for letting know, will check it out!

Thanks.
#57 written by jackmilney 2 years ago

Hiiiiiiiiiiiii………..

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

Thanks.
#58 written by jackmilney 2 years ago

I bookmarked this already dude great work

Regards

Anu
#59 written by tiffany jewellry 2 years ago

thank you for giving us a comment place.
i support your idea.hope you everying goes well.
#60 written by club penguin 2 years ago

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.
#61 written by tiffany jewellery 2 years ago

I apppraciate your comment ,your idea is wonderful.
wish you everything goes smoothly !
#62 written by tiffany rings 2 years ago

Thanks for the great widget! Going to add it to my installation next week.
I’ve also posted about it on the BlogEngine Forums
#63 written by Tiffany Earrings 2 years ago

Thanks for the great widget! Going to add it to my installation next week.
I’ve also posted about it on the BlogEngine Forums
#64 written by my blogging net 2 years ago

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.
#65 written by tiffany rings 2 years ago

Thanks for writing this truely cracking blog post, I enjoyed reading it
#66 written by hostwaffle09 2 years ago

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/
#67 written by tiffany 2 years ago

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.
#68 written by linksoflondon 2 years ago

Thanks for such a nice post.
#69 written by hkdedicatedhosting 2 years ago

thanks for sharing
i like it
it is very useful
thanks again
#70 written by classic tiffany 2 years ago

Thanks for writing this truely cracking blog post, I enjoyed reading it
#71 written by mini storage hk 2 years ago

thanks for sharing
#72 written by Billy D 2 years ago

Cool blog, just bookmarked it for later reference
#73 written by Marc Ecko 2 years ago

Hey I love your style I will subscribe for your feed please keep posting!
#74 written by Travelmaniak 2 years ago

Thats intresting, thanks for sharing. I’m sure others will see things the same way
#75 written by Lån Penge 2 years ago

Cool post – thanks a lot m8!
#76 written by запознанства 2 years ago

Thank you, for this code Cheers!
#77 written by anxiety cures 2 years ago

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
#78 written by Hoodia 2 years ago

Thanks.. Funny, I actually had this on my mind a few days ago..
#79 written by North Raleigh Neighborhoods 2 years ago

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.
#80 written by agoraphobia treatment 2 years ago

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
#81 written by panic disorder agoraphobia 2 years ago

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
Comments are closed
Comment Feed for this Post

Connector/Net 5.2.3 GA has been released

Tweets

Log in