QT MySql connectivity using Windows XP, Qt Creator 4.5.2(windows 32 bit)

mysql qt database-connectivity
Samir picture Samir · Oct 7, 2009 · Viewed 10.9k times · Source

Platform:

  • Windows XP
  • Qt Creator IDE 4.5.2

MySQL is setup here as well.

I want to establish database connection with Qt and MySQL. The following line 

QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");

generates error like below:

QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QODBC3 QODBC

It seems QMYSQL driver is absent here. What to do?

Answer

Lukáš Lalinský picture Lukáš Lalinský · Oct 7, 2009

You need to build the Qt/MySQL driver. See the documentation.

Related questions

Qt5.2 can find the mysql driver but can not load it

Operating System: win7 compiler : mingw4.8(come with Qt5.2) link to : Fedora core release 5, kernel 2.6.15-1.2054_FC5 smp on an i686 db = new QSqlDatabase(); db->addDatabase("QMYSQL"); db->setHostName("localhost"); db->setDatabaseName("myclinic"); db->setUserName("root"); db-&…

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More
How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More