Embedding MySQL into VB6

Posted on 2006-03-27
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.
Question by:rkulp
    LVL 84

    Accepted Solution

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

    Author Comment


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

    Author Comment

    After looking at the following link it is clear that MySQL is not available for anything but C/C++.
    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.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Suggested Solutions

    Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
    Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    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…

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now