Embedding MySQL into VB6

Can MySQL be embedded into a VB6 program? I have a program which uses Access as the db and am finishing a client-server version using MySQL.  I would like to be able to use the same program for each one by using MySQL for the stand-alone version. The db would have to be completely transparent to the user. I would like the user to be able to migrate the database to a server and use the client-server version with minimum difficulty.

This app is for volunteers in a charity to use.  There is no guarantee that anyone has any computer expertise, certainly not db administrator or programmer capability.
LVL 1
rkulpAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Have you read this:

http://www.mysql.com/products/embedded/

Should let you know everything, including cost (if any) and such. However, if you have no technically savvy users onsite this could be a bit problematic, since we all know that server installs don't always go as planned ...
0
 
rkulpAuthor Commented:
LSMConsulting:

Thanks for your response.

I have already seen their literature and felt it was oriented towards C/C++ and lacking for VB6 applications. You are so right about server installs. Hopefully, term "embedded" and phrases like "transparent to the user" that MySQL uses would mean the install would be as simple as copying the correct files and loading any required dynamic link libraries which can be done using InstallShield or any other good installer. The Access version I currently use installs fine because the db is nothing more than copying the .mdb file to the proper location.  It is not so clear what would be needed in VB6 to install the "embedded" db.  The typical MySQL install, even with their wizards, would be beyond most non-technical users.
0
 
rkulpAuthor Commented:
After looking at the following link it is clear that MySQL is not available for anything but C/C++.  http://dev.mysql.com/doc/refman/4.1/en/libmysqld-overview.html
Since VB6 can run a dll written and compiled in C, someone may know how to actually do what I would like to do.  Unfortunately, I am not that someone.

LSMConsulting: Thanks for your input.  I will award the points and close the question.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.