QMYSQL driver not loaded

[cydside]

Hi to all,
yes I've read the previous posts about it but nothing match my problem. I've compiled the MySQL driver following the Qt guide "SQL Database Drivers". Then I've checked the folder "C:\Qt\2010.02\qt\plugins\sqldrivers" in order to confirm the library installed:

10/02/2010  19.01             2.168 libqsqlite4.a
10/02/2010  19.01             2.178 libqsqlited4.a
10/03/2010  14.28             2.182 libqsqlmysql4.a
10/03/2010  14.28             2.192 libqsqlmysqld4.a
10/02/2010  19.01             2.178 libqsqlodbc4.a
10/02/2010  19.01             2.182 libqsqlodbcd4.a
10/02/2010  19.01           478.720 qsqlite4.dll
23/02/2010  09.44         1.728.157 qsqlited4.dll
10/03/2010  14.28           113.152 qsqlmysql4.dll
10/03/2010  14.28           942.617 qsqlmysqld4.dll
10/02/2010  19.01           154.624 qsqlodbc4.dll
10/02/2010  19.01           943.815 qsqlodbcd4.dll

10/02/2010  19.01             2.168 libqsqlite4.a
10/02/2010  19.01             2.178 libqsqlited4.a
10/03/2010  14.28             2.182 libqsqlmysql4.a
10/03/2010  14.28             2.192 libqsqlmysqld4.a
10/02/2010  19.01             2.178 libqsqlodbc4.a
10/02/2010  19.01             2.182 libqsqlodbcd4.a
10/02/2010  19.01           478.720 qsqlite4.dll
23/02/2010  09.44         1.728.157 qsqlited4.dll
10/03/2010  14.28           113.152 qsqlmysql4.dll
10/03/2010  14.28           942.617 qsqlmysqld4.dll
10/02/2010  19.01           154.624 qsqlodbc4.dll
10/02/2010  19.01           943.815 qsqlodbcd4.dll

To copy to clipboard, switch view to plain text mode 

it seems to be ok!

So, I've tried to test a simple app subclassing a QWidget:

#include <QSqlDatabase>
#include <QDebug>
#include "Widget.h"
#include "ui_Widget.h"
 
Widget::Widget(QWidget *parent) :
    QWidget(parent),
    ui(new Ui::Widget)
{
    ui->setupUi(this);
    QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
}
 
Widget::~Widget()
{
    delete ui;
}
 
void Widget::changeEvent(QEvent *e)
{
    QWidget::changeEvent(e);
    switch (e->type()) {
    case QEvent::LanguageChange:
        ui->retranslateUi(this);
        break;
    default:
        break;
    }
}

#include <QSqlDatabase>
#include <QDebug>
#include "Widget.h"
#include "ui_Widget.h"

Widget::Widget(QWidget *parent) :
    QWidget(parent),
    ui(new Ui::Widget)
{
    ui->setupUi(this);
    QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
}

Widget::~Widget()
{
    delete ui;
}

void Widget::changeEvent(QEvent *e)
{
    QWidget::changeEvent(e);
    switch (e->type()) {
    case QEvent::LanguageChange:
        ui->retranslateUi(this);
        break;
    default:
        break;
    }
}

To copy to clipboard, switch view to plain text mode 

but my "Application Output" has reported:

Starting C:\Documents and Settings\D44\Desktop\testMySQL\debug\testMySQL.exe...
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QODBC3 QODBC

Starting C:\Documents and Settings\D44\Desktop\testMySQL\debug\testMySQL.exe...
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QODBC3 QODBC

To copy to clipboard, switch view to plain text mode 

what is missing?

Thanks in advance

[Lykurg]

Have you also tried the "solutions" mentioned there under "Troubleshooting"? What does QApplication::libraryPaths() say?

[cydside]

Yes, I've tried:

qDebug() << QApplication::libraryPaths();

qDebug() << QApplication::libraryPaths();

To copy to clipboard, switch view to plain text mode 

and returns:

("C:/Qt/2010.02/qt/plugins", "C:/Documents and Settings/D44/Desktop/testMySQL/debug")

("C:/Qt/2010.02/qt/plugins", "C:/Documents and Settings/D44/Desktop/testMySQL/debug")

To copy to clipboard, switch view to plain text mode 

It's correct!
Ok, panic: Aaaaaaaagh!

[cydside]

Hi to all again,
I've found the following tutorial:

http://christopher.rasch-olsen.no/2009/04/14/qt-45-and-mysql-plugin-with-mingw-on-windows-xp/

http://christopher.rasch-olsen.no/2009/04/14/qt-45-and-mysql-plugin-with-mingw-on-windows-xp/

To copy to clipboard, switch view to plain text mode 

where the guy who has wrote it talk about a lack in the Qt documentation. It seems that the tutorial on How to build MySQL libraries on Windows is working only for nmake (Visual Studio). Do you, according to you experience, confirm that?
Unbelievable!!!

[GimpMaster]

One thing I found with mine (Note: I am using MSVC compiler and I got the plugin to compile just fine) is that you also need the libmysql.dll file and located somewhere in your path. The libmysql.dll file is NOT included if you just install the mysql header and source files only the .lib and *.h files are. So I re-installed with the client programs and copyed the .dll to my executable folder and it works!