QSqlDatabase: QMYSQL driver not loaded

[onder]

hi,

i am trying to connect mysql server bu i take this error :
"QSqlDatabase: QMYSQL driver not loaded"

i search forum and google i didnt find works answer.

i am using linux and my qt version 4.2
i install mysqlserver, mysqlclient and mysql libs.

please help.

thanks alot

onder

[jacek]

How did you install Qt?

[onder]

i am using pardus(linux distrubition).
i use pardus packet manager and i install
qt4
qt-sql-mysql
qt-doc

but default qt files still there (qt3)

onder

[jacek]

i use pardus packet manager and i install
qt4
qt-sql-mysql

Are you sure that this qt-sql-mysql package if for Qt 4.2?

[onder]

yes i checked :qt-sql-mysql for qt 4x

[jacek]

Try this:

#include <QCoreApplication>
#include <QSqlDatabase>
#include <QStringList>
#include <QtDebug>
 
int main( int argc, char **argv )
{
   QCoreApplication app( argc, argv );
   qDebug() << QSqlDatabase::drivers();
}

#include <QCoreApplication>
#include <QSqlDatabase>
#include <QStringList>
#include <QtDebug>

int main( int argc, char **argv )
{
   QCoreApplication app( argc, argv );
   qDebug() << QSqlDatabase::drivers();
}

To copy to clipboard, switch view to plain text mode 

it should print all available drivers (don't forget about QT += sql).

Make sure you create QCoreApplication or QApplication instance before you try to connect to the database.

[onder]

hi ,
i compile and run yopur code.
its result

("QSQLITE", "QMYSQL3", "QMYSQL", "QODBC3", "QODBC", "QPSQL7", "QPSQL")

[jacek]

And how about this?

#include <QCoreApplication>
#include <QSqlDatabase>
#include <QSqlError>
#include <QStringList>
#include <QtDebug>
 
int main( int argc, char **argv )
{
   QCoreApplication app( argc, argv );
   qDebug() << QSqlDatabase::drivers();
   QSqlDatabase db( QSqlDatabase::addDatabase( "QMYSQL" ) );
   qDebug() << db.lastError();
}

#include <QCoreApplication>
#include <QSqlDatabase>
#include <QSqlError>
#include <QStringList>
#include <QtDebug>

int main( int argc, char **argv )
{
   QCoreApplication app( argc, argv );
   qDebug() << QSqlDatabase::drivers();
   QSqlDatabase db( QSqlDatabase::addDatabase( "QMYSQL" ) );
   qDebug() << db.lastError();
}

To copy to clipboard, switch view to plain text mode 

[onder]

("QSQLITE", "QMYSQL3", "QMYSQL", "QODBC3", "QODBC", "QPSQL7", "QPSQL")
QSqlError(-1, "", "")

[jacek]

QSqlError(-1, "", "")

So it seems to work and most probably the problem lies in your code. As I already wrote, make sure you create QApplication or QCoreApplication instance before you use classes from the QtSql module.

[onder]

hi,

i understood but late understood.
you are right : problem QApplication instance problem.
thanks a lot

Onder

[noka]

("QSQLITE", "QMYSQL", "QMYSQL3", "QPSQL", "QPSQL7")
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QPSQL QPSQL7
QSqlError("", "Driver not loaded", "Driver not loaded")
Press <RETURN> to close this window...



Hello, this is my console output whenever I run this code below:

#include <QCoreApplication>
#include <QSqlDatabase>
#include <QSqlError>
#include <QStringList>
#include <QtDebug>

int main( int argc, char **argv )
{
QCoreApplication app( argc, argv );
qDebug() << QSqlDatabase::drivers();
QSqlDatabase db( QSqlDatabase::addDatabase( "QMYSQL" ) );
qDebug() << db.lastError();
}


What could be the problem, please?
Thanks in advance.
I'm using Qt5.8

[Lesiok]

You have to install Mysql client. QMysql driver is only interface to standard Mysql client.