MySQL database



  • QSqlDatabase: QMYSQL driver not loaded
    QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7
    My working MySQL database has started giving me the above error. I do not understand how the database is not loading the driver as it is plainly in sight.
    Anyone have any thoughts on how to correct this? Thanks in advance.



  • What OS are you on?

    This is a question that has been solved numerous times for different OSs https://www.google.co.uk/search?q="QMYSQL+driver+not+loaded"+site%3Aforum.qt.io


  • Moderators

    @collycrk

    Do you have MySQL installed and linked with the mysql lib?
    Under windows in most cases the dll for mySQL is not accesible by the application.



  • OS is windows;
    Here is the connection I am using.
    mydb = QSqlDatabase::addDatabase("QMYSQL");
    mydb.setHostName("127.0.0.1");
    mydb.setDatabaseName("ccs");
    mydb.setUserName("ccs");
    mydb.setPassword("xxxxxxxxxxx"); set with the real password of course



  • @koahnig
    The connection has been working for a couple of months already. Just now not connecting.


  • Moderators

    @collycrk

    Probably you need to check if the dll is still where you/the application expect(s) it. Typically a change of folders for the application is creating such problems. All that depends on your setup.

    Did you check out the link provided by @VRonin ?



  • The solution for the QMYSQL not being loaded was the environment path variable needed to point to the lib folder.
    In my case it is C:/MySqlDB/lib


Log in to reply
 

Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.