Can't load mysql.web assembly

Question

I am making a web application with ASP.net MVC3. I eventually want to use roleprovider and authentication used by a login form. So I have this code:

<authentication mode="Forms">
  <forms loginUrl="~/Home/Login" timeout="2880" />
</authentication>

<roleManager enabled="true" defaultProvider="MyRoleProvider">
  <providers>
    <add name="MyRoleProvider"
         type="StudentAdministratieProject.Authorisation.CustomRoleProvider"/>
  </providers>
</roleManager>

This code is obviously located in my web.config.

The error I get when I start the application:

Can't load file or assembly MySql.Web, Version=6.7.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d or one of the dependencies can't be loaded. The system cannot find the given file. ** Note that this is roughly translated from Dutch, the error was originally in Dutch.

Any ideas? Ive Googled a lot but can't find anything which helped me!

Answer 1

realize this is old, but in case its viewed later, here's what I found is cause / resolution.

I had to do some MySQL work on my regular .NET web server (db and web servers on same machine) so I used the MySQL installer (http://dev.mysql.com/tech-resources/articles/mysql-installer-for-windows.html). That little sucker seems to have gone and updated my .NET machine.config for me, how nice, so it's connector will work well with .NET. Stupid installer. Anyways when I went to go use a .NET / SQL Server app (no tie in to MySQL) I got the same error.

Easy enough fix (and your MySQL utilizing apps should still work just fine). Just comment out the MySQL reference(s) in the appropriate .NET framwework machine.config.

NOTE: the web page the error is on will tell you what machine.config file (and line number) is offending.

Link below is more detailed:

http://forums.asp.net/t/1928379.aspx

Answer 2

My Solution to this question as I do had the same issue:

Just add a reference to MySql.Web and it will go.

Answer 3

Try reinstalling MySQL .NET Connector 6.9.4 while uncheck “Web Providers” during the installation -

See more at: [ASP.NET with MySQL: Configuration Error (MySql.Web.v20)][1] http://technowide.net/2014/11/07/asp-net-with-mysql-configuration-error/

Answer 4

I have experienced the same situation and managed to fix the problem with these steps,

1. Read the error information carefully which provides helpful details to rectify the situation.
2. I wouldn't change the machine.config file.
3. As it says Application cannot find a reference to the assembly MySql.Web and the version it is trying to reference is Version=6.7.4.0.
4. Based on path you install MySql you will be able to find the correct assembly files, ex : C:\Program Files\MySQL\Connector NET 6.7.4\Assemblies\v4.0\MySql.Web.dll
5. Copy C:\Program Files\MySQL\Connector NET 6.7.4\Assemblies\v4.0\MySql.Web.dll file to bin folder. (I would copy all the files in C:\Program Files\MySQL\Connector NET 6.7.4\Assemblies\v4.0\ folder to bin folder)

Hope this helps! Thanks