By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,101 Members | 1,359 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,101 IT Pros & Developers. It's quick & easy.

VB 6 and MySql Database

P: 1
Please can you explain how i can use MySql database with Visual Basic 6. I want to consider using MySql as my backend but dont know how to go about it. Please, i will require you give a very clear explanation for my understanding. I am currently comfortable with Ms Access.

Mar 16 '07 #1
Share this Question
Share on Google+
2 Replies

P: 11
This can be a very long tedious process depending on how you wish to developm the SQL database. First, use the toturial that comes with VB in writing/opening an Access database. Now instead of connecting to the Access database you connect to the SQL database. Either, doing this by an ODBC connection or straight to the SQL database by your workstation. Now, this is a very simplified explanation. Mainly, get familiar with the wizard/sample from the VB program itself. I recommend obtaining an old Book about VB.
Mar 18 '07 #2

Expert 100+
P: 2,364
Great advice!

If you are not sure whether your machine is ODBC ready. Run a search against your C: Drive, when a reference to ODBC Data Source Admin. is found, go to it. As said above, you will need to physically list your SQL Database/Server and its address to your ODBC Data Source Admin.

Good luck with the project.

Mar 26 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.