Important: Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

Which database driver should I choose to connect to GearHost Server



  • I would like to connect to database hosted by gearhost.com. The database has been designed using MySQL language. In my mac, I haven't installed MySQL however, the driver for the Qt is installed. My question is is installing MySQL necessary? How can I design an application where the users of the application should not worry about installing extra driver in order to use the application? At this moment, running the following script

        qDebug()  <<  QSqlDatabase::drivers();
        QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
        db.setHostName("den1.mysql3.gear.host");
        db.setDatabaseName("xxxxxx"); //<-- I have the real data
        db.setUserName("xxxxxx"); //<-- I have the real data
        db.setPassword("xxxxxx"); //<-- I have the real data
        bool ok = db.open();
        qDebug() << ok;
    

    The output is

    ("QSQLITE", "QMYSQL", "QMYSQL3", "QODBC", "QODBC3", "QPSQL", "QPSQL7")
    QSqlDatabase: QMYSQL driver not loaded
    QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7
    false
    

    Choosing QSQLITE, the connection is always true even if I turn off the Internet connection. Obviously, there is something incorrect.



  • @CroCo

    Under windows you need a dll which you have to get separately from MySql webpage. For windows these are 2 libraries (the lib-stumpand the dll) to be correct.
    IIRC you can compile, link and run your application without, but you cannot connect.

    Hope this helps.


Log in to reply