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 <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();
}


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");



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");


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

[waynew]

Thanks for the help!