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.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Have you read this:


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 ...

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rkulpAuthor Commented:

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.
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.