Connectingto MySQL with QODBC3

**Philip_Anselmo** · 7th June 2006, 17:00

jjaja nevermind I just founded the myodbc on the fedora website :P

but now it throwsme a segment violation :S:S:S

is this code right?:

Qt Code:

Switch view

QSqlDatabase *defaultDB;
bool creaConexion()
{
 
    defaultDB = QSqlDatabase::addDatabase( DBDRIVER );
    defaultDB->setHostName( DB_HOSTNAME );
    defaultDB->setDatabaseName( "DRIVER={MySQL};Server="+DB_HOSTNAME+";Database="+DB_NOM+";Uid= "+DB_USR+";Pwd="+DB_PASS+";" );
    defaultDB->setUserName( DB_USR );
    defaultDB->setPassword( DB_PASS );
 
    if ( ! defaultDB->open() ) {
	QMessageBox::warning(0, "Fallo de conexiÃ³n", "No se pudo conectar con la base de datos: " + DB_NOM  + "tabla: " + DB_TABLA + "\n" +  defaultDB->lastError().driverText());
        return FALSE;
    }
    QMessageBox::information(0,"ConexiÃ³n estabecida","Conectado a: " + DB_HOSTNAME + " " + "tabla: " + DB_TABLA + " "+ DB_NOM);
    return TRUE;
}

QSqlDatabase *defaultDB;
bool creaConexion()
{

    defaultDB = QSqlDatabase::addDatabase( DBDRIVER );
    defaultDB->setHostName( DB_HOSTNAME );
    defaultDB->setDatabaseName( "DRIVER={MySQL};Server="+DB_HOSTNAME+";Database="+DB_NOM+";Uid= "+DB_USR+";Pwd="+DB_PASS+";" );
    defaultDB->setUserName( DB_USR );
    defaultDB->setPassword( DB_PASS );
    
    if ( ! defaultDB->open() ) {
	QMessageBox::warning(0, "Fallo de conexiÃ³n", "No se pudo conectar con la base de datos: " + DB_NOM  + "tabla: " + DB_TABLA + "\n" +  defaultDB->lastError().driverText());
        return FALSE;
    }
    QMessageBox::information(0,"ConexiÃ³n estabecida","Conectado a: " + DB_HOSTNAME + " " + "tabla: " + DB_TABLA + " "+ DB_NOM);
    return TRUE;
}

To copy to clipboard, switch view to plain text mode