db is not open when called the second time

[SGaist]

Hi,

You are calling open twice in a row, that's your the current problem.

[gabor53]

Hi @SGaist
I deleted the db.open() from

    qDebug() << "Open connection names in Addview: " << db.connectionNames ();

//	db.open ();

    if(!db.open ())
        {
            qDebug() << "The database (db) is NOT open!";

        }

and it still says The database (db) is NOT open!

[SGaist]

You should print the error you get from QSqlDatabase.

[gabor53]

@SGaist
The error message:
The database (db) is NOT open! QSqlError("", "Driver not loaded", "Driver not loaded")

[SGaist]

One of the thing you should first clean is how you handle your database. Your open statement should go in the same if where you create add the database.

Also, does fileQstring change at any time ? Do you handle that case ?

[gabor53]

@SGaist
fileQString doesn't change. I keep using the same db.

[SGaist]

In that case, why not just open the database in your main function and be done with it ?

[gabor53]

@SGaist
You mean the main function of MainWindow_

[SGaist]

No, I mean main in your main.cpp

[gabor53]

@SGaist
I did the following:

#include "mainwindow.h"
#include <QApplication>

int main(int argc, char *argv[])
{
    QApplication a(argc, argv);
    MainWindow w;

    QSqlDatabase db;
    QString fileQstring = "C:/Programming/Projects/FolkFriends_1_0/db.db";


    db = QSqlDatabase::addDatabase ("QSQLITE");
    db.setDatabaseName (fileQstring);
    qDebug() << "Connection Display created in connection(). ";

    bool OK = db.open ();

    if(OK == true)
        {
            qDebug() << "The db (MainWindow) is open!";
        }
    else
        {
            qDebug() << "The db (MainWindow) is not open!";
        }

    if(!db.open ())
        {
            qDebug() << "The database (db) is NOT open!" << db.lastError ();

        }

    db.open();

    w.show();

    return a.exec();
}

I still get
The query is NOT active. QSqlError("", "Driver not loaded", "Driver not loaded")

[SGaist]

What version of Qt are you using ?

Do you have write access to that location ?

[gabor53]

@SGaist
Yes . I have write access. Using Qt 5.7 on Windows 10

[SGaist]

Are you experiencing that using Qt Creator to start your application ?

[gabor53]

@SGaist
It starts ok.

[gabor53]

@gabor53
I think the problem is that it first executes function Addview() from mainwindow.cpp. this crates the first half of the messages:
QSqlQuery::exec: database not open
The query is NOT active. QSqlError("", "Driver not loaded", "Driver not loaded")

After mainwindow.cpp it executes main.cpp where I create the db connection and open the db. This gives normal messages:

Connection Display created in main.cpp.
The db (MainWindow) is open!

Clearly the problem is that it tries to run the query before it opens the db. I just still don't know why it processes mainwindow.cpp first and main.cpp second.

[jsulm]

@gabor53 Then move

MainWindow w;

after setting up the connection.

[gabor53]

@jsulm
This worked. Thank you.