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 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 MySQL Database

The following instructions tells you how to create a MySQL Database and MySQL Username to be used...

How to Use Access Database in your Website

Microsoft Access Databases can be used in all Web Hosting Plans. You should upload your own...

HOW TO TAKE MYSQL DATABASE BACKUP FROM SOLIDCP?

This article will guide you to generate the backup of your MySQL database from SolidCP. Login to...

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...