Greetings,
I am attempting to make a windows application that among other things allows the user to view tables and edit their contents in a MySQL database. I'm using VS 7, and i'm getting problems with the following. I add in a new dataset to my project, in the development window it says drag components in this window from either the toolbox or the server browser. Well I have the MySQL database I want to edit active in the server browser. I drag the appropriate table I need to edit into the window and I get an error saying my data adapter type doesn't support ODBC. Even getting VS to connect to my database was a hassle, I downloaded the MyODBC driver, and added in the ODBC manager (control panel/administrative tools) as a system wide data name, and when i go into VS and ->add connection, the provider list only shows OLE DB providers. there's a OLE DB provider for ODBC drivers, so I select that ad it can read and even view / query the tables in my db. But whenever I try to add the tables to a dataset it is giving me ODBC compatibility issues. If someone can at least tell me if it's possible in VS/VB to allow people to interact with a MySQL database I would very much appreciate it ! this is really driving me crazy.