Access mdb file - cant get list of tables or views with db.tables() list

[ChrisW67]

In the code above, where do you set the variable "db"?

[GoranSimunic]

Here is widget.h

#ifndef WIDGET_H
#define WIDGET_H
 
#include <QWidget>
#include <QtSql/QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>
#include <QStringList>
 
namespace Ui {
class Widget;
}
 
class Widget : public QWidget
{
    Q_OBJECT
 
public:
    explicit Widget(QWidget *parent = 0);
    ~Widget();
 
public:
    QString vrijeme;
    QString vrijemeKraj;
    QSqlDatabase db;
    QSqlQuery sqlTrazi;
    QStringList list;
 
 
    bool conOpen(){
 
        QSqlDatabase db=QSqlDatabase::addDatabase("QODBC");
 
               db.setDatabaseName("DRIVER={Microsoft Access Driver (*.mdb)};FIL={MS Access};DBQ=D:/Programi/SynSetup/Synesis/Pupilla.mdb");
 
        if(!db.open())
        {
 
            //qDebug() << "Database Error" << db.lastError(); //<< db.lastError().text();
 
            return false;
 
        }
 
        else
 
        {
            return true;
        }
 
    }
 
 
 
    void closeConnection(){
        db.close();
    }
 
private:
    Ui::Widget *ui;
};
 
#endif // WIDGET_H

#ifndef WIDGET_H
#define WIDGET_H

#include <QWidget>
#include <QtSql/QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>
#include <QStringList>

namespace Ui {
class Widget;
}

class Widget : public QWidget
{
    Q_OBJECT

public:
    explicit Widget(QWidget *parent = 0);
    ~Widget();

public:
    QString vrijeme;
    QString vrijemeKraj;
    QSqlDatabase db;
    QSqlQuery sqlTrazi;
    QStringList list;


    bool conOpen(){

        QSqlDatabase db=QSqlDatabase::addDatabase("QODBC");

               db.setDatabaseName("DRIVER={Microsoft Access Driver (*.mdb)};FIL={MS Access};DBQ=D:/Programi/SynSetup/Synesis/Pupilla.mdb");

        if(!db.open())
        {

            //qDebug() << "Database Error" << db.lastError(); //<< db.lastError().text();

            return false;

        }

        else

        {
            return true;
        }

    }



    void closeConnection(){
        db.close();
    }

private:
    Ui::Widget *ui;
};

#endif // WIDGET_H

To copy to clipboard, switch view to plain text mode 

[d_stranz]

Your problem is that on line 32, you declare another instance of your variable "db", which hides the one you declare as a member variable of your class. As soon as conOpen() ends, this instance of "db" goes out of scope and is destroyed. Your member variable "db" is never initialized to anything.

To fix it, simply remove the word "QSqlDatabase" from line 32.

[GoranSimunic]

Thank you very much for nice explantion. Definitely begginer mistake.(trying to find button solved)