I have problems with QMYSQL Driver!
-
Sorry, than I cannot help any further.
Good luck! -
Thanks for your help.
At the begin there is no mysql folder, but I made a new project named mysql and put it in the sqldrives. That is what should I do? Or I did it wrong?
-
There is (or at least should be) a mysql.pro file in your Qt sources. If there isn't, you either are not looking hard enough, or you have an incomplete installation of the Qt sources. The former is more likely. Just making up a .pro file yourself is obviously not going to result in a valid project that is going to help you build the drivers.
-
Andre I think I found the mysql.pro through the source files. I
ll try tomorrow to make the QMYSQL Driver. If I
ll have any problems, I`ll make a reply tomorrow. -
I found the right mysql.pro, I tiped
@
qmake "INCLUDE+=C:..." "LIBS+=C:...\libmysql.a" -o Makefile mysql.pro
mingw32-make
@then I got !http://img651.imageshack.us/img651/614/unledswx.png!
Where is the problem? -
Did you prepare the MySql libs for use with the MinGw compiler, as is described in the countless other topics you claimed to have read on this issue?
-
Yes I did. I crated the libmysql.a
-
@kallo here are the steps to build mysql plug-in driver ( and I assure you it works :-) ):
- download mysql-connector-c-noinstall-6.0.2-win32 binary package from mysql downloads.
- open %QTDIR%\src\plugins\sqldrivers\mysql\mysql.pro in QtCreator
- add LIBS and INCLUDEPATH in mysql.pro to match with your mysql-connector-c-noinstall-6.0.2-win32 path
- after mysql.pro is succesfully build, copy the qsqlmysqld4.dll + qsqlmysql4.dll in %QTDIR%\Desktop...etc...\plugins\sqldrivers (there should already be qsqlite4.dll)
- copy libmysql.dll in %QTDIR%\Desktop...etc...\bin
that's all
-
No cincirin, that is not all. It depends on your toolchain. If you use minGw, as kaloo is doing, you need some additional steps.
-
I use mingw toolchain and they work.
-
So I did how cincirin said
!http://img51.imageshack.us/img51/5876/unledcj.png!the output says
@
cannot find -libmysql
@Where should libmysql stay? or what I did wrong?
-
Do you have libmysql*.a* ? Don't you have libmysql.lib ?
Also you have to put only the path to libmysql.lib LIBS += yourPath -
I have libmysql.a
-
From what I see, you didn't download mysql conector binary builds. Your path is towards xampp/...
-
I have mysql-connector-c-noinstall-6.0.2-win32, extracted in the xampp/mysql folder
edit:
if I put
@
INCLUDEPATH += C:/xampp/mysql/include
LIBS += C:/xampp/mysql/lib/libmysql.a@
before
@
include(../../../sql/drivers/mysql/qsql_mysql.pri)
include(../qsqldriverbase.pri)
@
The output gives me 83 errors with undefined reference -
Ok, then your project should look as: ... LIBS += c:/xampp/mysql/lib
Anyway, I don't have libmysql*.a* -
I created the libmysql.a with
@ reimp C:/xampp/mysql/lib/libmysql.lib @ -
You have to put only the path to mysql lib directory, because qsql_mysql.pri already do: LIBS += -llibmysql
Did you try with LIBS += -Lc:/xampp/mysql/lib ? -
the mysql.pro is now:
@
TARGET = qsqlmysqlSOURCES = main.cpp
INCLUDEPATH += C:/xampp/mysql/include
LIBS += C:/xampp/mysql/libinclude(../../../sql/drivers/mysql/qsql_mysql.pri)
include(../qsqldriverbase.pri)
@and the output sais
@
C:/xampp/mysql/lib No such file: Permission Denied
@but the folder is not read only... I don`t know what to do...
-
Your project should be:
@
TARGET = qsqlmysqlSOURCES = main.cpp
include(../../../sql/drivers/mysql/qsql_mysql.pri)include(../qsqldriverbase.pri)
INCLUDEPATH = C:/xampp/mysql/include
LIBS += -LC:/xampp/mysql/lib
@