.Net : How to connect to MySQL using OLE DB Provider?

[selvialagar]

Private Connection As New System.Data.OleDb.OleDbConnection
Private Command As New System.Data.OleDb.OleDbCommand
 Connection.ConnectionString = "Provider=MySQLProv;Data Source=localhost;User Id=root;"
 Command.Connection = Connection
Connection.Open()
 

When this code is executed, it shows "MySQLProv is not registered in the local machine"

How to connect Mysql database using OLE DB provider? What should I do for this?

[Plater]

Do you actually have the mysql provider installed on your computer?

It looks like you have the correct connection string, but unless you named your database "localhost", I think you need to fix the database name
http://www.connectionstrings.com/?carrier=mysql

[Curtis Rutland]

I'm pretty sure it's not a conn string issue, based on his error.

Have you installed the provider? Is it installed by default when you install MySql? Do you have MySql on your machine?

I've never used MySql, but I've used other DBMSs that will install their .net connectors, OleDB providers, and ODBC drivers when you install their client tools. For example, when you install IBM's Client Access software, it installs the IBMDA400 provider on your machine.

Search around for installing the provider. Also look for the native connector, as that will be easier to use.