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.

Was this answer helpful?

 Print this Article

Also Read

How to set "Write Permissions" to Files and Folders

By default and for security reasons, all the folders in your web hosting space are read-only. For...

How to Backup and Download your MS SQL 2005 or 2008 or 2012 Database

How to Backup and Download your MS SQL Database===================================You can back up...

How to Create and Use Microsoft SQL Server 2005, 2008 OR 2012 R2 Database

The following instruction tells you how to create a Microsoft (MS) SQL Database 2005 or 2008...

How to Send Emails using PHP Contact Form

Click on the following link to download a fully functional PHP Contact Form that you can upload...

How to Display PHP Errors

Displaying PHP Errors are turn off by default.  However, you can turn on/off Displaying...