This isn't I believe a COTS problem but I am posting it so that others won't spend a day resolving it.
I accidentally upgraded by MySQL Data Connector to 6.9.3 , whilst installing the latest MySQL database 5.6.21. After which a generate of my COTS application thrw the error above.
MySQL seems to have a new all in one installer that updates among other things the machine.config file. See this link for some information.
http://stackoverflow.com/questions/17...
In my case it added a heap of entries to C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\Machine.Config that referenced, MySql.Web.v20. I changed all of them to MySql.Web, AND also the entry in my projects web.config and my project is up and running again.
The only problem I have now is if I create a new project the new web.config files seems to get the wrong assembly name ie MySql.Web.v20. I don't know where this is picked up from ( the registry ?) maybe a COTS person could advise ?
Could not load file or assembly 'MySql.Web.v20, Version=6.9.3.0
-
i have same problem, it's seem ADO.net Mysql v6.9.3.0 not support yet by COT... just use v6.6.6
-
-
no its not a COTS issue, it a bug in the MySQL installer.
http://bugs.mysql.com/bug.php?id=74080
6.9.3.0 ( and 6.8) works fine with COT, after installing 6.9.3 just make the changes to machine.config as an administrator and it will work. -
-
I can confirm 6.8.3 does work with no issue on a test computer. I will pass this info along to developers and hopefully support for 6.9.3 will be included in the next release.
-
-
Finbar,
It appears you are correct about the bug. Note that while IIS Express and Visual Studio are 32-bit, the app generator is 64-bit. You will want to change the machine.config file located at C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config as well.
For more detailed instructions and anyone else that encounters this error, please refer to this blog post for instructions:
http://codeontime.com/blog/2014/09/fix-for-mysql-connectornet-693 -
-
Yes I found that out by accident !, ,as it resolves the second question in my post.
Would it be possible somewhere on the site to compile a list of "tested with" for maybe databases, visual studio, windows OS/IIS, browser release levels for the latest COTS release ?
Keep up the good work -
-
Try reinstalling MySQL .NET Connector 6.9.4 while uncheck “Web Providers” during the installation -
See more at: http://technowide.net/2014/11/07/asp-net-with-mysql-configuration-error/ -