Attn Qt programmer: need help with QMYSQL3 driver (error "not loaded")

20 Aug 2004

      Hello,

I am trying to write a simple Database application on 9.0 and it's acting 
strange wrt the Qt MySQL drivers. I have also tried converting TrollTech's 
example 'book1' database application (from teh Qt source tarball's example 
dir)  to use mysql and it give the same error.
It compiles fine but when try to run it I get the following error:

./<either one of the binaries>
QSqlDatabase warning: QMYSQL3 driver not loaded
QSqlDatabase: available drivers: QMYSQL3
Failed to open books database: Driver not loaded
Driver not loaded

All I have done to the book1 example is change ../connection.h: changed the 
driver name, and 
database/user/passwd/host.

I tried searching archives/web for this but the only thing similar I found 
were people who didn't have the QMYSQL3 driver at all.

Is there some form of system-wide configuration I have to do to enable the use 
of the mysql "driver"?

This is using SuSE 9.0 QT/KDE3    qt3-3.2.1   to be exact.

Can anyone explain what I need to do to "load" the driver, or what's wrong? I 
can send a tarball (176K) to anyone who wants to have a look at it.

The application I'm trying to write is only 2 files, main.cpp and the .ui 
file, main.cpp shown here:

---------------------CUT---------------------------
#include 
#include 
#include "form1.h"

bool createConnection()

{

    // create the default database connection

    QSqlDatabase *defaultDB = QSqlDatabase::addDatabase("QMYSQL3", "pos");
    if ( ! defaultDB ) {
        qWarning( "Failed to connect to driver" );
        return FALSE;
    }

    defaultDB->setDatabaseName( "mytestdb" );
    defaultDB->setUserName( "me" );
    defaultDB->setPassword( "mypass" );
    defaultDB->setHostName( "90.0.0.200" );

    if ( ! defaultDB->open() ) {
        qWarning( "Failed to open books database: " +
                  defaultDB->lastError().driverText() );
        qWarning( defaultDB->lastError().databaseText() );
        return FALSE;
    }

    return TRUE;

}

int main( int argc, char ** argv )
{
    QApplication a( argc, argv );
    if (!createConnection())
        return 1;
    Form1 w;
    w.show();
    a.connect( &a, SIGNAL( lastWindowClosed() ), &a, SLOT( quit() ) );
    return a.exec();
}

---------------------CUT---------------------------

Thanks.

-- 
----------------------------------------------------
Jonathan Wilson
Cedar Creek Software     http://www.cedarcreeksoftware.com

Attn Qt programmer: need help with QMYSQL3 driver (error "not loaded")

JW