Printable View
I have really no idea about MySQL, but I really want to learn it since I've found that it's better than Access and I'm planning to shift from Access to 100% MySQL database. What software paackages do I have to download? How can I connect it to the program I'm using, for example Vb6/.NET? I have already a knowledge of SQL commands, and I already downloaded and installed a MySQL GUI but I don't know what to do with it. I feel like I'm lacking something, a MySQL server perhaps?
The database engine/server (there are several editions, which one depends on your situation), and a driver/provider so your program can connect to it.Quote:
Originally Posted by Encoder
Almost the same as you would with Access.Quote:
How can I connect it to the program I'm using, for example Vb6/.NET?
For VB6 just change the Connection String to use the driver/provider you downloaded.
For VB.Net you could just do the same, but it would be better to switch to the MySQL connector (download link in the DB FAQs)
Note that there will be some differences in SQL statements, as each database system uses its own syntax.