How do I connect my ASP.net application to MySQL database?

In general, 2 different methods can be used to connect an ASP.net application to MySQL database.

  • Using ODBC .net data provider
  • Using a MySQL native .net data provider

We only provide support for using ODBC .net data provider to connect to MySQL.

Our servers do not have any MySQL .net data provider installed because of the lack of standardization in this market. If you prefer to use native drivers to connect to MySQL, you can upload the data provider to your bin directory.

Here is a list of available MySQL .net data providers

MySQLDriverCS:
http://www.salleurl.edu/~manuellv/Public/english.8.1.html

ByteFX MySQL Driver:
http://sourceforge.net/projects/mysqlnet/

Core Lab MySQLDirect .NET Driver:
http://crlab.com/mysqlnet/

Was this answer helpful?

 Print this Article

Also Read

I get an error 'A potentially dangerous Request.Form value was detected from the client ' when I hit submit on my ASP.NET Webform. What can I do?

This error is caused by a newly introduced feature of .NET Framework 1.1, called "Request...

I receive an error when trying to access an ASP.NET page within a subweb. What do I do?

The ASPNet (user as which ASP.NET runs) user permission does not inherit into the subweb....

How did I send email from ASP.net ?

You have to use System.Web.Mail namespace Below is the code snippets : using System.Web.Mail;...

Why can I still access my ASP.NET pages even though I disabled anonymous access to my directory?

After disabling anonymous access in the permission manager in the control panel, ASP.net pages...

I get an error "Access denied to 'D:\public_html\xxx\xxx\web.config'. Failed to start monitoring file changes" when I try to open an ASP.net page. What can I do?

This error usually means that the ASPNet user does not have adequate permission to access the...