SQLite3 and Qt

Hi there folks!

I've got a little big problem which is already giving me a huge headache...

I am trying to establish a connection to a file database created using sqlite3, but for some reason I can't!

I've first tried to use the following code:

Code:

---

QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setHostName("localhost");
db.setDatabaseName("medadmin");
db.setUserName("****");
db.setPassword("*****");

---

and it didn't work. After some research I found out that Sqlite3 doesn't use permissions on its databases and so I removed the last two lines of the above code (needless to say it didn't work).

What am I doing wrong??? should I set the host name to the full path of the file???

Thanks in advance,
:o

Hi,

use the full path as the database name. You do not need to set the host as well.

You don't have to specify the user and password either, since sqlite doesn't support authorization.

Thank you very much!