[solved] QtSql and XAMPP MySql - "QMYSQLdriver not loaded"

killerman

Hi, I' ve installed XAMPP and i've created a database but i get error while opening it.

Here is my programm:

QCoreApplication a(argc, argv);

QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("localhost");
db.setDatabaseName("people");
db.setUserName("root");
db.setPassword("");

if(db.open())  qDebug() << "Opened";
else qDebug() << "Not opened";

return a.exec();

i get en error:

QsqlDatabase: QMYSQL driver not loaded
QsqlDatabase: available drivers ... QMYSQL...

So, the driver is installed byt it wont work.

What is wrong ?

mcosta

Hi and welcome to devnet,

I think there are a lot of similar threads in the forum; BTW the first thing to check is if the MySQL client library (not the Qt driver) is available in the PATH.

QSqlDatabase::drivers() return the list on Qt drivers installed on the machine.
When you try to use a driver, it needs to load the native DB client library; if the client library cannot be loaded the driver loading fails.

This is why you can see the driver as available but you're not able to load it.

killerman

"BTW the first thing to check is if the MySQL client library (not the Qt driver) is available in the PATH."

It is not. This is my PATH.

PATH=C:\Documents and Settings\All Users\Dane aplikacji\Oracle\Java\javapath;
D:\aplikacje\Borland\CBUILD~1\Bin ;
D : \Ap1ikacje\Borland\CBUILD~1\Projects\Bp1;
C:\WINDOWS\system32;
C:\WINDOWS ;
C:\WINDOWS\system32\wbem;
C:\PROGRAM FILES\QUICKTIME\QTSYSTEM;
D:\Aplikacje\Internet Explorer;
C:\Program Files\QuickTime \QTSystem;

I've tried to use the code below(in cmd) but it still don't work...

 set PATH=C:\xampp\mysql

mcosta

Hi,

you need to set it as System environmental variable

killerman

Ok. I did it using this tutorial:
http://www.computerhope.com/issues/ch000549.htm#windowsxp

but QT still gives the same error...

SGaist

Hi and welcome to devnet,

What does QSqlDatabase::lastError() return ?

killerman

it returns:

"QSqlError<"", "Driver not loaded", "Driver not loaded">"

mcosta

HI,

can you show again your PATH? Is the mysqlclient.dll in the PATH?

killerman

PATH=C:\Documents and Settings\All Users\Dane aplikacji\Oracle\Java\javapath;
D:\aplikacje\Borland\CBUILD~1\Bin ;
D : \Ap1ikacje\Borland\CBUILD~1\Projects\Bp1;
C:\WINDOWS\system32;
C:\WINDOWS ;
C:\WINDOWS\system32\wbem;
C:\PROGRAM FILES\QUICKTIME\QTSYSTEM;
D:\Aplikacje\Internet Explorer;
C:\Program Files\QuickTime \QTSystem;
C:\xampp\mysql;

I've added the folder with mysql in xampp. Is it wrong?

i've searched for mysqlclient.dll in xampp file but it is not there.

There are only mysqlclient.lib files in .../xampp/lib and .../xampp/lib/debug

mcosta

you need to add C:\xampp\lib in the PATH

killerman

Ok. It works fine now.

Thank You :)

mcosta

You're welcome.
Don't forget to mark the thread as SOLVED