I installed MySQL’s Connector/Net v6.2 on my dev machine and used the Entity Framework to query a MySQL server without any problems.Â Then I uploaded the same code to my hosting company’s server and I kept getting errors telling me “Unable to find the requested .Net Framework Data Provider”.Â In order to make it work, I had to do the following:
- Uploaded MySql.Data.dll to my bin directory
- Uploaded MySql.Data.Entity.dll to my bin directory
- Added the following lines to my web.config file:
<add name=”MySQL Data Provider” invariant=”MySql.Data.MySqlClient” description=”.Net Framework Data Provider for MySQL” type=”MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=18.104.22.168, Culture=neutral, PublicKeyToken=c5687fc88969c44d” />
I hope this saves someone else some headaches!