Qt creator upgrade to 2.0 no sql support linux

[jllangston]

I recently upgraded to 2.0 from 1.3.1 and have no sql drivers on linux.

Specifically i am looking to use MySQL. Works fine in 1.3.1, but I try the following code in 2.0:

qDebug() << QSqlDatabase::drivers();
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");

qDebug() << QSqlDatabase::drivers();
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");

To copy to clipboard, switch view to plain text mode 

I then get this result:

QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: 
QSqlError(-1, "Driver not loaded", "Driver not loaded")

QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: 
QSqlError(-1, "Driver not loaded", "Driver not loaded")

To copy to clipboard, switch view to plain text mode 

In my sdk directory, there is no src directory to build the drivers. I did, however find the following directory:

qtcreator-1.3.85/bin/sqldrivers

Here there was an existing libqsqlite.so

I downloaded the src code for qt 4.6.3, built the mysql driver successfully, and copied it to this folder, but to no avail.

I've changed to qt version inside the previous version of creator (1.3.1) to every version of qt that i have installed: 4.6.3 and 4.7.0 beta. Run a rebuild and it runs just fine, with the following code and response:

#include <QtCore/QCoreApplication>
#include <QtSql>
#include <QDebug>
 
int main(int argc, char *argv[])
{
    QCoreApplication a(argc, argv);
 
    qDebug() << "sql drivers" << QSqlDatabase::drivers();
 
    return a.exec();
}

#include <QtCore/QCoreApplication>
#include <QtSql>
#include <QDebug>

int main(int argc, char *argv[])
{
    QCoreApplication a(argc, argv);

    qDebug() << "sql drivers" << QSqlDatabase::drivers();

    return a.exec();
}

To copy to clipboard, switch view to plain text mode 

response:

sql drivers ("QSQLITE", "QMYSQL3", "QMYSQL")

sql drivers ("QSQLITE", "QMYSQL3", "QMYSQL")

To copy to clipboard, switch view to plain text mode 

My question is then, where is the new version of qtcreator looking for these driver files? And, more importantly, how do i get the new version running with sql support.

[spawn9997]

I am having the exact same problem. The addDatabase function kicks out this error. Our code has not changed since creator 1.2.1. My test show we can access our database at the command line but not in creator 2.0. I have success using qtcreator-2.0-beta (qtcreator-1.3.83) but not qtcreator-rc1(qtcreator-1.3.85 ) or qtcreator-2.0. Sounds like a bug; I'm going back to beta until this is fixed unless someone can get a workaround going.

[scap]

Same exact issue here as well. I am not even using the sdk that I downloaded to get the latest qtcreator. I am using the ubuntu standard qmake and qt libs that were working in 1.3??? guess I am going back too.

[jllangston]

I eventually got it to work. I had to download the source code for 4.7 and rebuild with sql support. Works great now!

[bazmrl]

The not finding SQL plugins is because the default plugin path has been hard coded to /home/berlin or something rather than the Qt install path.