How to connect MySQL database with OLE DB?

diegofaria

New member
Joined
Sep 1, 2010
Messages
1
Programming Experience
Beginner
I`m newbie and dont understanding how can i connect the vb.net with MySQL with OLE DB.

How can i do this ?
 
You create an OleDbConnection with the appropriate connection string and call Open. You can find the appropriate connection string format here:

ConnectionStrings.com - Forgot that connection string? Get it here!

That said, you would also need to have installed a MySQL OLE DB provider. I'd suggest that you should rather download and install Connector/Net from the MySQL web site. Once installed, you can reference the MySql.Data.dll assembly and use a MySql.Data.MySqlClient.MySqlConnection instead.
 
Back
Top