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 Create and Use MySQL Database

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

How to Send PHP Mail with Authentication

  You can download a fully functional PHP Contact Form for your Website at: Contact Form...

How to Display PHP Errors

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

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 TAKE MYSQL DATABASE BACKUP FROM SOLIDCP?

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