I would like to design a GUI to connect to a MySQL database on my local machine. I tried to use VB.net 2003 to do this but for the MySQL version 5.0.8 I needed the MySQL Connect/Net and it required .net Framework 2.0. I installed .net Framework 2.0 and it doesn't work with Visual Studio .net 2003.
How can I connect a database using MySQL with Visual Studio .net 2003? What programs do I need to download? Is there a version of MySQL that I can download that will let my use the .net framework 1.1 instead of 2.0 for ODBC and ADO connection strings?
I started this project using Oracle but the overhead required by using Oracle was more than I wanted to spend in resources to design this database/GUI.