Can't connect to SQLite DB



  • Doing my first steps in Qt Creator and lost already:

    To a basic, otherwise unchanged starting app from the Qt wizzard, I have added sql to the project file

    @ QT += core gui sql@

    and the lines below to mainwindow.cpp.
    @
    #include <QSqlDatabase>

    QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
    db.setDatabaseName("/home/vaettchen/testSQL/myDB.sqlite");
    bool db_ok = db.open();@
    

    According to various sources here on the Qt WebSite and on StackOverflow (where nobody could help me), I had expected that this would do it. But I get a compiler error

    @../testSQL/mainwindow.cpp:20:1: error: 'db' does not name a type@
    

    where line 20 is the db.setDataBaseName() line.
    I have tried to find out via Google what this means and what can be done about it but the comments I found were not very useful.

    Using Qt Creator 2.7.0 (Qt 4.8.4) on Linux 3.5



  • Hi vaettchen.
    Is libsqt4-sql and libqt4-sql-sqlite installed in your system?

    Regards.



  • Thanks SergioDanielG - I do have the modules, drivers etc installed. This is all very confusing and, for a greenhorn like me, does look very inconcsistent.

    The odd thing is that depending how I start the project (from a sample project or plain wizzard) things seem to be different. I have partly solved the issue by prepending the command with void and other strange stuff that looks irregular to me.

    I have adapted the relationaltablemodel to use my existing sqlite file and make progress from here. I'll happily ask more questions once I understand better what I'm going at all...

    Thanks once more,
    Rainer


Log in to reply
 

Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.