In this visual guide I\’m going to show how you can use MyODBC in .NET 2005. It\’s rather sneaky because when you install MyODBC it is not readily available in the data source option after installation. You have to create a connection string first in order to make use of MyODBC. I have tested this in Visual Web Developer 2005 Express and should work in other Visual Studio 2005 versions.
You should download and install MyODBC before beginning. It is available at MySQL Connector/ODBC download section. I\’m going to use MyODBC 3.51.12 for this guide.
1. Go to menu bar -> Tools -> Connect to Database or click the Connect to Database icon
2. Choose Microsoft ODBC Data Source (or you may choose .NET Framework Data Provider for ODBC, either will be just fine) then click Continue.
3. Choose the Use Connection String radio button and click Build…
4. In Machine Data Source tab click New…
5. You can either choose User Data Source or System Data Source.
6. Browse the list of drivers and choose MyODBC
7. Finish… (not yet done…)
8. Configure the connector and test it. Don\’t forget to fill out every detail specially the name of the Data Source. Choose a database. Click Ok.
9. Now, go to your data and look for Configure Data Source… it will bring up the Configure Data Source wizard.
10. Click New Connection… and choose Microsoft ODBC Data Source, click Continue.
11. Now you can see in the choices the name of MyODBC data source you have just configured. Click Ok, then Next.
12. Save your connection string and from there you may specify your SQL statements and use the query builder.
The rest is up to you as it is very similar to using the query builder in MS SQL Server databases.