How to connect mysql database using Ttables

Posted on 2006-05-26
Last Modified: 2010-04-05
Anybody can help me? I'm new with this mysql and i want to know on how to connect mysql database to Ttables. Just an example source codes will do.

Question by:ryan_sabarre

    Author Comment

    Thanks in advance.
    LVL 11

    Assisted Solution

    First option would be to build a DSN using the mysql drivers on the computer you intend to use the application on... and then with ADO Database component or BDE database component connect to the DSN (if you need to use only the TTable then it's BDE, but if not, and TADOTable suits you then use the ADO components.
    Also you could use the DBExpress Components to connect to your database (some say it's better... I never tryed it).
    Also there is an open source database component pack called Zeos (look it up on google) It is enhanced for connectinfg to open source databases like PostgreSQL and MySQL and others too.
    So here's your answer
    LVL 22

    Accepted Solution


    If you would to use TTable(BDE), then you can download the ODBC drivers and connect using it with the TTable

    or you can download the Ole db driver from mysql and use the Ado components

    you can use ZeosLib to connect

    if you need a direct connect method, which i prefer more than Ado or BDE, here are few libraries

    for free


    or one of the best MyDac, but it's not free


    Author Comment

    Sorry, but i need a sample source code for this. I don't want to use a third party components in my application.

    Anyway, i already got the answer of my question. I'll still give you points for this.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
    In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    737 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

    16 Experts available now in Live!

    Get 1:1 Help Now