Create database

[waynew]

Newbie having trouble creating a database here.
Following code compiles ok, but no database is created and I can't find any sqlite file.

#include "makeDB.h"
#include <iostream>
#include <QString>
#include <QtSql>
 
void makeDB(QString dbName) {
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setHostName("localHost");
db.setDatabaseName(dbName);
db.setUserName("logger");
db.setPassword("logger");
}

#include "makeDB.h"
#include <iostream>
#include <QString>
#include <QtSql>

void makeDB(QString dbName) {
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setHostName("localHost");
db.setDatabaseName(dbName);
db.setUserName("logger");
db.setPassword("logger");
}

To copy to clipboard, switch view to plain text mode 

#include <QtGui/QApplication>
#include <QString>
#include <QtSql>
#include "mainwindow.h"
#include "makeDB.h"
#include "createTable.h"
#include "ui_mainwindow.h"
 
 
int main(int argc, char *argv[])
{
    QApplication a(argc, argv);
    MainWindow w;
    w.show();
 
    makeDB("log1");
 
    createTable();
 
    return a.exec();
}

#include <QtGui/QApplication>
#include <QString>
#include <QtSql>
#include "mainwindow.h"
#include "makeDB.h"
#include "createTable.h"
#include "ui_mainwindow.h"


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

    makeDB("log1");

    createTable();

    return a.exec();
}

To copy to clipboard, switch view to plain text mode 

What am I doing wrong here? Thanks!
Waynew

[Lykurg]

QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setHostName("localHost");
db.setDatabaseName(dbName);
db.setUserName("logger");
db.setPassword("logger");

QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setHostName("localHost");
db.setDatabaseName(dbName);
db.setUserName("logger");
db.setPassword("logger");

To copy to clipboard, switch view to plain text mode 

SQLite don't support user and password. So simply write:

QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("c:/path/to/you/databases/or/whatever/dbname.db");

QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("c:/path/to/you/databases/or/whatever/dbname.db");

To copy to clipboard, switch view to plain text mode 

Instead of dbname.db you can choose whatever you want.

[waynew]

Thanks for the help!