SQLite databases cannot be stored in the Qt resource system. You must put it into regular files and distribute them along your application.

The reason is simple: The database name is just the path to the file. Qt does not intercept the file name but hands it over directly to the SQLite functions (by calling toUtf8() on the “path”), which in turn try to open that file – and will eventually fail, of course.

Would it be possible with another kind of database? for example mysql or mssql? or is it generally not possible to store db’s in qt resources?

No, it would not be possible with other database too. Even if you’re using some embedded database (mysql comes into mind), these would suffer from the same problem, that Qt does not intercept the path.

so there’s no way to use databases with qt on mobile device?
And i have to use for example .csv ?

Provide the database file in your application bundle. I’m pretty sure you can have those in every mobile environment. Also, keep in mind that a file in a resource is read-only, you would never be able to write to that database.

ok, thanks for info!
but now i have a problem!
how can i use the information in the file/db in my app?
i’d like to read and write to that file/db and want to bring the file/db with the app, so that i don’t need to copy it on device manually.
or is there another way to add it to my project? without the .qrc?

As far as I know it’s possible to add this to some settings in the qmake project files, at least for symbian. But I have no experience on this. Please use the forum search and/or Google – I’m sure this was asked before.

Here’s the solution for everybody who’s interested in:

use:

and add this to your .pro file:

Thanks to Volker!

Hi All,
I have tried in the same way.But i didnt get it.
Basically i am developing the meego application in windows dev enviornment using Qt creator.

Following are my pro file contents,

So when i tried to build the file, automatically the other folde is added into my project directory and showing test.sqlite inside it;

But when i tried with the following code

Please give some suggestions over this issue.

Thanks,
Vsh.Vshnu

[EDIT: code formatting, please use @-tags, not stars (*), Volker]

Hi Vsh.Vshnu,

Follow the SQLite examples given in Forum Nokia:
Creating an SQLite database in Qt [wiki.forum.nokia.com]
Searching for data in a database in Qt [wiki.forum.nokia.com]

Best regards,
Leon

leon.anavi wrote:

Hi Vsh.Vshnu,

Follow the SQLite examples given in Forum Nokia:
Creating an SQLite database in Qt [wiki.forum.nokia.com]
Searching for data in a database in Qt [wiki.forum.nokia.com]

Best regards,
Leon

Hi leon.anavi,
My problem is different.Its becasuse i am not able to open a existing sqlite database inside project main folder.
I want the sqlite files to be inside my application package file??

Then, what is the path stored in variable dbname?

Hi Volker,
Its simply
QString dbName=“test.sqlite”;

Iam developing for meego in windows developement enviorment using Qt creator

the target path of your app is /usr/local/bin, the path of your db is test.sqlite – so the complete path is /usr/local/bin/test.sqlite. Sounds quite ok for me (in regard to the setup, a database file in /usr/local/bin is a no-go!).

Do you have a test.sqlite that actually is packed in your setup?

And be aware, the packing options are Symbian only!. It is ignored for any other operating systems, including Meego! It is for reason, that Matze5590 has put them into the symbian scope!

vsh.vshnu wrote:

Hi Volker,
Its simply
QString dbName=“test.sqlite”;

Iam developing for meego in windows developement enviorment using Qt creator

Try to use the absolute path. You can get the file path of the application executable using QCoreApplication::applicationFilePath [doc.qt.nokia.com]

Cheers,
Leon