Hi,

I am using
Qt Code: 
  1. QSqlDatabase QSqlDatabase::addDatabase ( QSqlDriver * driver, const QString & connectionName = QLatin1String( defaultConnection ) )
To copy to clipboard, switch view to plain text mode 

http://doc.qt.nokia.com/4.7/qsqldata...#addDatabase-2

to connect to a mysql Embedded database (using my.cnf), here is the code:

Qt Code: 
  1. #include <QtCore/QCoreApplication>
  2. #include <QtSql>
  3.  
  4. #include "QMYSQLDriver"
  5. #include <mysql.h>
  6.  
  7. int main(int argc, char *argv[])
  8. {
  9.     //QCoreApplication a(argc, argv);
  10.     {
  12.         MYSQL *mysql;
  13.  
  14.         static char *server_options[] = \
  15.         { "mysql_test", "--defaults-file=/home/cquiros/temp/mysql/my.cnf", NULL };
  16.         int num_elements = (sizeof(server_options) / sizeof(char *)) - 1;
  17.  
  18.         static char *server_groups[] = { "embedded", NULL };
  19.  
  20.         qDebug() << "Loading embedded";
  21.         mysql_library_init(num_elements, server_options, server_groups);
  22.         mysql = mysql_init(NULL);
  23.         mysql_options(mysql, MYSQL_READ_DEFAULT_GROUP, "embedded");
  24.         mysql_options(mysql, MYSQL_OPT_USE_EMBEDDED_CONNECTION, NULL);
  25.  
  26.         mysql_real_connect(mysql, NULL,NULL,NULL, "database1", 0,NULL,0);
  27.  
  28.  
  29.         //mydb = QSqlDatabase::addDatabase("QMYSQLE","mydb"); //Add the database connector to MySQL
  30.  
  31.         QMYSQLDriver *drv = new QMYSQLDriver(mysql);
  32.  
  33.         mydb = QSqlDatabase::addDatabase(drv,"connection1"); //Add the database connector to MySQL
  34.         qDebug() << "Embedded driver added";
  35.  
  36.         mydb.setDatabaseName("test");
  37.  
  38.         if (!mydb.open()) //Try to opens the database
  39.         {
  40.             qDebug() << "Error while opening the database";
  41.         }
  42.         else
  43.         {
  44.             qDebug() << "DB test opened";
  45.             QSqlQuery tables(mydb);
  46.             QString sql;
  47.             sql = "SELECT count(*) FROM system";
  48.             if (tables.exec(sql))
  49.             {
  50.                 tables.first();
  51.                 qDebug() << "Total records is: " << tables.value(0).toString() << " ok.";
  52.             }
  53.             else
  54.             {
  55.                 qDebug() << tables.lastError().databaseText();
  56.             }
  57.  
  58.         }
  59.     }
  60.     qDebug() << "Closing DB";
  61.     QSqlDatabase::removeDatabase("connection1"); // correct
  62.     qDebug() << "DB closed";
  63.  
  64.     //return a.exec();
  65.     qDebug() << "En of program....";
  66. }
To copy to clipboard, switch view to plain text mode 

The code works however, there is a segmentation fault when the program finished. If I trace the error it happens is the QMYSQLDriver (from QT sources) when the driver closes:

Qt Code: 
  1. void QMYSQLDriver::close()
  2. {
  3.     if (isOpen()) {
  4. #ifndef QT_NO_THREAD
  5.         mysql_thread_end();
  6. #endif
  7.         mysql_close(d->mysql); //Here is the failure
  8.         d->mysql = NULL;
  9.         setOpen(false);
  10.         setOpenError(false);
  11.     }
  12. }
To copy to clipboard, switch view to plain text mode 

Any idea what is wrong or if this is not the way to connect using the embedded driver I would appreciate some help.

Thanks,
Carlos.