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 Send PHP Mail with Authentication

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

Restore of MS SQL Server Database is not allowed

Dear Sir,For security reasons, you will not be able to Restore or Import your existing MS SQL...

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 Display PHP Errors

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

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