File missing error for: /QtSql/private/qsqlcachedresult_p.h [SOLVED]

[mogles]

I am using Qt Creator 2.1.0 on Linux Mint

I have been researching how to connect to a SQLite database and in the process I added an include for <QtSql/qsql_sqlite.h>. I am now getting the file missing error. The QTSql folder doesn't have a sub-folder named private.
X
Also, in the past I have always used a connection string like:
"Data Source=/Home/Mark/Databases/MotorData.sqlite;Version=3;New=False;Compress=True;"
I'm having difficulty time finding a similar reference in the Qt documentation. Doesn't the SQLite wrapper need the above info?

Your help is most appreciated.

[lgeyer]

To use a SQLite database:

• add the sql module to your .pro file (QT += sql).
• include <QtSql/QSqlDatabase>
• use QSqlDatabase::addDatabase("QSQLITE") to get a database object
• set the SQLite filename using setDatabaseName()

Just see the various "examples":http://qt.gitorious.org/qt/qt/blobs/4.7/examples/sql/connection.h.

[andre]

In your applications, do not rely on private headers. They may or may not be available, and they may change or be removed at any time, at any release.

[mogles]

[quote author="Lukas Geyer" date="1321339075"]To use a SQLite database:

• add the sql module to your .pro file (QT += sql).
• include <QtSql/QSqlDatabase>
• use QSqlDatabase::addDatabase("QSQLITE") to get a database object
• set the SQLite filename using setDatabaseName()

Just see the various "examples":http://qt.gitorious.org/qt/qt/blobs/4.7/examples/sql/connection.h.[/quote]

Most of what you suggested I already had in place. The thing I find that seems significant is there is no example for connecting to an existing database. Connecting to an in memory database following the example provides a connection as expected. However, I am trying to connect to an existing database. Most all posts show using a windows path. So how is setDatabaseName used when you have an existing database?

[lgeyer]

Just point to your existing database file.
@
database.setDatabaseName("c:/path/to/database.file");
@

[mogles]

Thanks for your patience. Life is good again.:)

[lgeyer]

You're welcome. Feel free to edit the topic to "[Solved] ..." if it has been solved for you to indicate that it actually is and that there is a solution inside.