How to connect VB.NET to MySQL database?

[albertlse]

I'm trying to connect my VB.NET project to MySQL Database. I used ODBCDataAdapter and ODBCConnect, but failed.
Actually I can successfully connect to MySQL Database in VB 6.0 last time using ODBC.
How can I make it in VB.NET?
Please guide, thank you!

[Iceman5]

When I Connected my SQLserver database I just Added a connection in the "Server Explorer".
Checked that ole db pro.... sql server was setted
checked for the database, name, password
then ok

I did almost same with my MS Access database. Only difference is that I chooced MS Jet 4.0 ole db provider

After that.
Added a dataadapter (dbconnection is created also) and select what info you want
and then right click on your dataadapter and generate a dataset and you should got what you want

Not sure if the info is what you wanted but hopefully it can help some.

[Sheppe]

To connect via ODBC you'll need the driver: http://www.mysql.com/products/myodbc/index.html

I'm not sure if there's a way to connect via OLEDB.

[Nalar]

www.planetsourcecode.com has an example up.