DB problem

Hi,

I'm trying to connect to my database whit the following code:

Code:

---

#include <QSqlDatabase>
...
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("myhost");
db.setDatabaseName("mydb");
db.setUserName("myuser");
db.setPassword("mypass");
db.open();

---

but I'm getting this error:

main.cpp:5:24: QSqlDatabase: No such file or directory
main.cpp: In function `int qMain(int, char**)':
main.cpp:17: error: `QSqlDatabase' undeclared (first use this function)
main.cpp:17: error: (Each undeclared identifier is reported only once for each function it appears in.)
main.cpp:17: error: expected `;' before "db"
main.cpp:18: error: `db' undeclared (first use this function)
mingw32-make[1]: *** [debug\main.o] Error 1

Add QT+=sql to your project file and rerun qmake.

And how exactly I do that?
I must just add this command in the project file?

Yep, it worked...

I'm getting "Driver not loaded" error now.
I ready this article http://doc.trolltech.com/4.2/sql-dri...gin-on-windows but i can't compile the plugin. Someone have a tutorial to compile MySQL plug-in?

Try the one in Qt Centre wiki: Building the QMYSQL plugin on Windows using MinGW

Thank you jpn!

I was reading this article :)