QMYSQL database driver installation files

[babygal]

I want to use QMYSQL.
What are the driver installation files I need to install to work with my Qt4.6.2
and where can i get it?
Which version of QMYSQL I need to use ?
What are the procedures?

[saa7_go]

Read this guide.

[babygal]

I'm not able to execute the command 'reimp' as per the instruction in the link . And where can I get the download files for the reimp?

Goto the sub-directory lib/opt and run reimp libmysql.lib to produce the liblibmysql.a file. This is the import library to use with MinGW.

[saa7_go]

You can download mingw-utils in http://sourceforge.net/projects/ming...ar.gz/download or http://sourceforge.net/projects/ming....lzma/download.

[babygal]

How can I be sure that the driver files are installed correctly?

[saa7_go]

You can use QSqlDatabase::drivers() to check all of the available drivers.

[babygal]

int main(int argc, char *argv[])
{
 
    QApplication app(argc, argv);
 
    qDebug() << QSqlDatabase::drivers();
    if (!createConnection())
        return 1;
 
    Q_INIT_RESOURCE(cardiacprocessingtoolkit);
    MainWindow mainWin;
    mainWin.show();
 
 
    return app.exec();
}

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

    QApplication app(argc, argv);

    qDebug() << QSqlDatabase::drivers();
    if (!createConnection())
        return 1;

    Q_INIT_RESOURCE(cardiacprocessingtoolkit);
    MainWindow mainWin;
    mainWin.show();


    return app.exec();
}

To copy to clipboard, switch view to plain text mode 

The debug message reads as:
("QSQLITE", "QMYSQL3", "QMYSQL", "QODBC3", "QODBC")

but the connection fails ! what's wrong?

[Lykurg]

but the connection fails ! what's wrong?

Show us how you connect to your database and look at the error message.

[babygal]

Show us how you connect to your database and look at the error message.

static bool createConnection()
{
    QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
    db.setHostName("localhost");
    db.setDatabaseName("DatabaseName");
    if (!db.open()) {
        QMessageBox::critical(0, qApp->tr("Cannot open database"),
            qApp->tr("Unable to establish a database connection.\n"
                     "This example needs MYSQL support. Please read "
                     "the Qt SQL driver documentation for information how "
                     "to build it.\n\n"
                     "Click Cancel to exit."), QMessageBox::Cancel);
        return false;
    }
 
 
 
 
 
    return true;
}

static bool createConnection()
{
    QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
    db.setHostName("localhost");
    db.setDatabaseName("DatabaseName");
    if (!db.open()) {
        QMessageBox::critical(0, qApp->tr("Cannot open database"),
            qApp->tr("Unable to establish a database connection.\n"
                     "This example needs MYSQL support. Please read "
                     "the Qt SQL driver documentation for information how "
                     "to build it.\n\n"
                     "Click Cancel to exit."), QMessageBox::Cancel);
        return false;
    }

 



    return true;
}

To copy to clipboard, switch view to plain text mode 

[saa7_go]

Can you connect to your MySQL server using MySQL client (mysql.exe) without username and password? Make sure your database "DatabaseName" exist and MySQL service is running.

[babygal]

Can you connect to your MySQL server using MySQL client (mysql.exe) without username and password? Make sure your database "DatabaseName" exist and MySQL service is running.

No I am not able to connect.I've no idea what's wrong.

[Lykurg]

Then probably you have to start your server!

[babygal]

Read this guide.

In this guide, there is a prerequisite:
Download the MySQL installer (the essentials msi-package is enough) from MySQL.com and install it (make sure to choose to install the headers as-well.
But there are many downloads in that site MySQL.com . Which one do I choose?

[Lykurg]

take the MySQL Community Server. It will have all necessary files.

[babygal]

take the MySQL Community Server. It will have all necessary files.

i downloaded and installed : mysql-5.1.49 - win32.msi

[babygal]

You can download mingw-utils in http://sourceforge.net/projects/ming...ar.gz/download or http://sourceforge.net/projects/ming....lzma/download.

I download the mingw-utils in http://sourceforge.net/projects/ming...ar.gz/download .
As per the guide : http://www.qtcentre.org/wiki/index.p...ws_using_MinGW
the second prerequisite is : Download the mingw-utils .Copy the contents of the binary tar.gz to %QTDIR%/bin.
My question is which bin folder exactly?There are a few bin folders. QT version I'm using is 2010.02.1

[saa7_go]

I assume your Qt installation is in C:\. So, copy your mingw-utils contents(in bin directory) in C:\Qt\2010.02.1\qt\bin.

[babygal]

I downloaded the MySQL Server 5.1 into path
C:\Program Files\MySQL\MySQL Server 5.1 .

But there is no \lib\opt\ in my :
C:\Program Files\MySQL\MySQL Server 5.1\lib.

Instruction from the guide link :-

How to Build the Plug-in :
-Open a Qt Command Prompt and go to wherever you installed the MySQL server (C:\Program Files\MySQL\MySQL Server 5.0 is the default location).
-Goto the sub-directory lib/opt and run reimp libmysql.lib to produce the liblibmysql.a file. This is the import library to use with MinGW.

But I do not find any sub-directory lib/opt . So how do I proceed?

[saa7_go]

Is there libmysql.lib in your MySQL lib directory ?

[babygal]

Is there libmysql.lib in your MySQL lib directory ?

No, there isn't ..