In window XP, I failed to open a database file comes from Android phone.

goetz

If you use SQL databases, you should at least make yourself comfortable with using the command line tools.

Without the actual files I cannot comment any further. It's completely unclear what's going wrong.

pico

Hi, Volker:
Is there anyway to send you the database file?
Could you help me to check it?
Because I use the sqlite tool downloaded from the SQL web, it works well.

So, I can not understand why I can not use the Qt's SQL dll to handle that.

Thanks a lot.

BR,
Pico

andre

Well, you could always put it up on one of the many free services for such things. Perhaps using dropbox in a public folder?
Please just post the link here, so others than just Volker can take a look at your issue if they are interested.

pico

Hi, Sir:
The link to this database file is http://dl.dropbox.com/u/21382345/blake_cruiser.db
If possible, please help me to know what I do wrong.

Thanks a lot.

BR,
Pico

[EDIT: fixed link, Volker]

goetz

I cannot open the database file on Ubuntu (sqlite 3.4.2 and 3.6.16) nor on Mac OS X (sqlite 3.6.12).

Is the OS/lib/program that creates the database file using some kind of encryption?

pico

Hi, Volker:
This database file comes from Android phone.
I just copy it out, and try to parse it.

But, I can use sqlite3_analyzer downloaded from "www.sqlite.org" to open it.

So, I guess this might be related to version.

If so, could you give me a piece of advice to solve the version issue?
For example, could I get the updated library from Qt's web for SQL?
Or, something like that...

BR,
Pico

goetz

Ok, problem found: The SQLite version in Android is newer than that bundled with Qt. Actual problem is, that it is too new and contains a "WAL feature":http://www.sqlite.org/wal.html that older versions cannot deal with.

Android has SQLite 3.7.x
Qt 4.7.1 has SQLite 3.6.19

I can easily change a working database file to be locked out of a 3.6.x client by changing that mentioned WAL flag.

The good news is: You can build the SQLite plugin of Qt with a newer version of SQLite. The docs have instructions on how to do this in section "QSQLITE for SQLite (Version 3 and Above)":http://doc.qt.nokia.com/4.7/sql-driver.html#qsqlite of the "SQL Database Drivers":http://doc.qt.nokia.com/4.7/sql-driver.html page. Just use the newest SQLite version from the webpage.

On Jira, there is an open bug report "QTBUG-16607":http://bugreports.qt.nokia.com/browse/QTBUG-16607 which requests an update of the built in SQLite version to 3.7.x. You can vote for it, this may accelerate it a bit.

pico

Hi, Volker:
I really appreciate your great help.
What you said make me know lots of things about database file.

Thanks a lot.

BR,
Pico

pico

Hi, Volker:
Although I followed what you showed to me, I failed to generate a QtSql4.dll.
I could get libqsqlite4.a, qsqlite4.dll, and something else.
However, I can still NOT make a sql query successfully.

Could you give me more details for how to build a new sql driver and install it?

Thanks a lot.

BR,
Pico

goetz

It could be, that your application grabs an old version of the plugin. Make sure, that
"QCoreApplication::addLibraryPath() ":http://doc.qt.nokia.com/4.7/qcoreapplication.html#addLibraryPath

You can check the version of the used SQLite with

@
select sqlite_version();
@

Issue this in your program and check that you actually use the newly built plugin, not the old one.

goetz

Just for the records, if anyone stumbles over this old thread: In the recent release 4.8 of Qt the included SQLite has been updated to version 3.7.7.1.