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

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

Answer 2

I managed to resolve this by running MySQL Installer and updating to the latest files available.

Answer 3

Another solution:

• check version of .NET used by application pool of your web application. here we consider version is 2.0
• go to folder C:\Program Files (x86)\MySQL\Connector NET 6.7.4\Assemblies\v2.0 (<- depend of your version)
• copy dll from previous folder to C:\Windows\assembly

Answer 4

As Beginner to .NET, i also experienced the same situation..

But it can be resolved very simple step.

Select references from solution explorer . Right click on it, Select Add reference, select mysql.web from the list of assemblies, then add it.

After adding mysql.web assembly , you can get rid out from this error.

Thanks!!

Answer 5

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 6

I have been looking for answer and I find the solution that work for me on fix-for-mysql-connectornet-693

You just need to delete ".v20" from every instance of MySql.Web.v20 in

C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config

and

C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config

You can edit files in Notepad (Run As Administrator!).