MySql connector version 6.3.6 not loading

Hi Ray,

I have deployed an application where I am using ASP.NET 4 + Entity Framework 4.0 and MySql connector version 6.3.6.0. I developed this application using VS 2010 and on my local machine everything works fine.

However when I deployed on the server and called the default.aspx page the following error appeared:

-------------------------------------------------------------------------

Could not load file or assembly 'MySql.Data, Version=6.3.6.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IO.FileLoadException: Could not load file or assembly 'MySql.Data, Version=6.3.6.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

-------------------------------------------------------------------------

I tried appending the following settings in my web.config:

<system.data>
<DbProviderFactories>
<clear />
<add name="MySQL Data Provider"
invariant="MySql.Data.MySqlClient"
description=".Net Framework Data Provider for MySQL"
type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data,Version=6.3.6.0, Culture=neutral,PublicKeyToken=c5687fc88969c44d"/>
</DbProviderFactories>
</system.data>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name ="MySql.Data" publicKeyToken="c5687fc88969c44d" />
<bindingRedirect oldVersion="0.0.0.0-6.3.5.0" newVersion="6.3.6.0" />
</dependentAssembly>
</assemblyBinding>
</runtime>

As well as set trust level="Full" but yet this problem is not going away.

This is my second day on this new Winhost account where I have been migrated from GoDaddy because of the fact that GoDady does not allow latest MySql connector for .Net to be installed. I spoke to Winhost pre-sales guys and they said that any version of MySql connector will work.

 

You will need to upload the MySQL .Net Connector 6.3.6 in your applications Bin folder. Currently we only have version 6.2.3 installed on the servers GAC.