I have problems with QMYSQL Driver!

DenisKormalev

What should you do after building mysql plugin?
Hm. Maybe use it?

kaloo

Where I did wrong?
!http://img641.imageshack.us/img641/1700/unledvfc.png!

I can`t find

libqsqlmysql4.a
libqsqlmysqld4.a
qsqlmysql4.dll
qsqlmysqld4.dll

koahnig

[quote author="kaloo" date="1307294661"]
"qmake "INCLUDEPATH+=C:\MySQL\include" "LIBS+=C:\MYSQL\MySQL Server <version>\lib\opt\libmysql.lib" mysql.pro"

it says mysql.pro don`t exist. What shoul I do?
[/quote]

your last statement was the reason to ask my question, if mysql.pro exists. I guess you added this file now. Your output does not show the error message anymore. Is that right?

kaloo

Yes, I have mysql.pro now, and there is no output error message, but I can`t find the 4 files...

koahnig

What do you have in your mysql.pro?

kaloo

@QT += core
QT += sql

QT -= gui

TARGET = mysql
CONFIG += console
CONFIG -= app_bundle

TEMPLATE = app

SOURCES += main.cpp
@

but I`m guessing that must be other things in the file...

koahnig

typically you would have also the following statements @
INCLUDEPATH ...
LIBS ...
@
I do not know the details of qmake, but possibly you can do as you did.

Maybe should do a
@
mingw32-make clean
@
to clean up the directories and retry.
Unfportunately, I cannot give more or better advice, since I am not using mingw on windows.

kaloo

I need a good tutorial for helping me to make the QMYSQL Driver for Qt 2.2 ( latest version )

koahnig

did you try "these":http://www.lmgtfy.com/?q=qmsql+tutorial+

kaloo

Yes... I tried... I know how to use google...

koahnig

Sorry, than I cannot help any further.
Good luck!

kaloo

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?

andre

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.

kaloo

Andre I think I found the mysql.pro through the source files. Ill try tomorrow to make the QMYSQL Driver. If Ill have any problems, I`ll make a reply tomorrow.

kaloo

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?

andre

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?

kaloo

Yes I did. I crated the libmysql.a

cincirin

@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

andre

No cincirin, that is not all. It depends on your toolchain. If you use minGw, as kaloo is doing, you need some additional steps.

cincirin

I use mingw toolchain and they work.