[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Embedding MySQL into VB6

Posted on 2006-03-27
3
Medium Priority
?
367 Views
Last Modified: 2013-12-25
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.
0
Comment
Question by:rkulp
  • 2
3 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 200 total points
ID: 16317392
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
 
LVL 1

Author Comment

by:rkulp
ID: 16317453
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
 
LVL 1

Author Comment

by:rkulp
ID: 16317509
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses
Course of the Month19 days, 5 hours left to enroll

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question