This is what I did for a asp.net(vb.net) app with mysql so there shouldn't be to much different with straight vb.net
1) MyODBC - MyODBC is a 32-bit ODBC Driver, also known as MySQL ODBC 3.51 Driver. After you have downloaded and installed MyODBC, you will need to setup a new DSN (Program Files > Administrator Tools > DataSource ODBC. Go to "System DSN" and click on "Add" Scroll down to MySQL ODBC 3.51 Driver and click on "Finish" (your not done yet though!)
Next enter the information for your MySQL Database, note Data Source Name is what you wish to call the DSN, for instance "mysqldsn". When finished click on "Test Data Source", if it connects, then click on ok, if not check your entries and try again.
2) ODBC .NET Data Provider - The Open Database Connectivity (ODBC) .NET Data Provider is an add-on component to the .NET Framework. It provides access to native ODBC drivers the same way the OLE DB .NET Data Provider provides access to native OLE DB providers.
After you have downloaded the exe, simply install and your done... go to step 3...
3) MDAC 2.7 - This may or may not be needed with your system, if your running Windows XP, then your ok, everyone else needs to download the new version...
Before you install MDAC 2.7, be sure to stop IIS and reboot after the install is complete...
OK There are a couple of key things to notice and remember here, the first is on line one in the Page Declaration. Notice the CompilerOptions='/R:"C:\Program Files\Microsoft.NET\Odbc.Net\Microsoft.Data.Odbc.dll"', this is needed in order for your application to find the odbc.net dll. Of course you can set this in your webconfig file but that's beyond the scope of this post...
The second important line to notice is: Import Namespace="Microsoft.Data.ODBC". You must import the Microsoft.Data.ODBC namespace in order for your application to use the ODBC objects...
Finally, where we setup the dsn connection notice that the name "mysqldsn" is the same one I used as an example when setting up the dsn in step 2, be sure to change this to the name you entered when setting up your dsn...