[Solved] QT & MySQL - What must be done? [Beginner]

[kaivolde]

Hi folks,

I want to start accessing a MySQL-DB programatically with Qt.

The basic question is - what do I have to do?

Here is my setup:
qt-opensource-windows-x86-msvc2013_64_opengl-5.3.1
Windows8.1 64bit
Visual Studio 2013 Express
MySQL (I installed nearly everything, connectors, etc, the main version is 5.6 (I think))

In the Qt-directory plugins/sqldrivers there are already the two files qsqlmysql.dll and qsqlmysqld.dll

The methodcall QSqlDatabase::isDriverAvailable( "QMYSQL" ) gives me a "true".

But a call to QSqlDatabase::addDatabase( "QMYSQL" )
gives the warnings:
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7

So I think the driver is there but it can't be loaded. What is wrong? Do I have to compile some additional things?

Many thanks in advance.

Best regards
Kai

[SGaist]

Hi,

You need to have the path to the mysql dlls in your PATH environment variable. You can add it in the run part of the Project panel

[kaivolde]

Works - perfect!

To be a little bit more precise for people who will run into the same problem. On my sytem I had to expand the PATH variable with the following path:
C:\Program Files\MySQL\MySQL Server 5.6\lib

Thanks SGaist

BTW: I did not find this essential hint in the current Qt-docs. Is there a way to add it there?

[SGaist]

You have the Troubleshooting section of the "SQL Database Driver" chapter in the documentation but it might use that information.

[marcnnn]

sorry got the same problem but i am not able to fix it...

got qt 5.3 mingw 32 on 64 bit win 7
mysql 5.6 dev install

on linux every thing is fine but Win :(

[kaivolde]

Hi,
I guess the problem you encounter now is that the libraries of the downloaded MySQL-distribution are for VisualStudio (not MinGW).

So you must try to fetch the MinGW-libs.

Regards
Kai

[marcnnn]

how i change to msvs but still got trouble... can't compline driver ...

[SGaist]

It's a bit vague, what errors are you getting ?