Good day all.
Im currently using this code in my project to open a mysql database file
..... mydatabase.cpp....
	
	- bool myDatabase::createDatabaseConn() 
- { 
-     QSettings-  settings ("ATSTech"- ,  "ats_shopfront")- ; 
 
-   
-     settings.beginGroup("database"); 
-   
-   
-         db.setHostName(settings.value("server").toString()); 
-         db.setDatabaseName("dbname"); 
-         db.setUserName(settings.value("databaseUsername").toString()); 
-         db.setPassword(settings.value("databasePassword").toString()); 
-   
-         if (!db.open()) { 
-             //QMessageBox::critical(0, QObject::tr("Database Error"), db.lastError().text()); 
-             return false; 
-         } 
-         return true; 
-   
-     settings.endGroup(); 
- } 
        bool myDatabase::createDatabaseConn()
{
    QSettings settings("ATSTech", "ats_shopfront");
    settings.beginGroup("database");
    QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
        db.setHostName(settings.value("server").toString());
        db.setDatabaseName("dbname");
        db.setUserName(settings.value("databaseUsername").toString());
        db.setPassword(settings.value("databasePassword").toString());
        if (!db.open()) {
            //QMessageBox::critical(0, QObject::tr("Database Error"), db.lastError().text());
            return false;
        }
        return true;
    settings.endGroup();
}
To copy to clipboard, switch view to plain text mode 
  
No when i use this from my other pages like so 
	
	- myDatabase *getinfo = new myDatabase(); 
-     getinfo->createDatabaseConn(); 
        myDatabase *getinfo = new myDatabase();
    getinfo->createDatabaseConn();
To copy to clipboard, switch view to plain text mode 
  
i get the following warinings/errors
	
	- QSqlDatabasePrivate::addDatabase: duplicate connection name 'qt_sql_default_connection', old connection removed. 
        QSqlDatabasePrivate::addDatabase: duplicate connection name 'qt_sql_default_connection', old connection removed.
To copy to clipboard, switch view to plain text mode 
  
Is there any way to in the code at the top to check if there is already a connection and if so use that one instead of removing and creating a new one to the database.
im sure that would make things faster aswell
regards
Donovan Hoare
				
			
Bookmarks