How to Connect your ASP.Net Application to MySQL Database
You can connect your ASP.Net Application directly to your MySQL Database by using "MySQL Connector Net" which is a fully-managed ADO.NET driver for MySQL. The MySQL Connector Net 6.2.4 driver is already installed on our Web Hosting Servers. You can download the MySQL Connector Net 6.9.8 for your computer at the following Address. MySQL Connector Net 6.9.8 Download: https://dev.mysql.com/downloads/connector/net/
Very Important:
If you use another version of MySQL Connect, you may get the an error that is similar to the following error:
The error is "Could not load file or assembly 'MySql.Data, Version=5.1.7.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified."
Please do the following to fix the error: In the references folder of the application, select the Mysql.Data reference and change the property "Specific Version" from "True" to "False".
We are sorry that ODBC is not supported on our Web Servers.