How to connect to mySQL hosting by OledbDataAdapter???

[nokia6230ivn]

I'm trying to connect to mySQL hosting by OledbDataAdapter but it couldn't. Please teach me how to do?
I did as followings:
1. Connect to server by Server Explorer.
2. Drag OledbDataAdapter to form.
3. Right click, choose "Configer Data Adapter" and "New Connection..."
4. In "Add Connection" window, choose "Change...".

A "Change Data Source" window appear, but there is not mySQL Database for user to choose.

Please teach me to continue...?

 

[jmcilhinney]

If you want to use OleDb then you'll have to do it in code. I suggest that you download Connector/Net from MySQL and use it instead though. It's a MySQL-specific ADO.NET provider, along the lines of SqlClient for SQL Server.