MySQL driver - Very strange problem. PLEASE HELP ME. Thanks.

[diego]

Hi all.
I am trying to connect Mysql with QT on Window XP.
I made steps:
1. Installed QT SDK
2. Installed MySQL
3. I run Qt Command Prompt to Build the QMYSQL Plugin on Windows.

cd %QTDIR%\src\plugins\sqldrivers\mysql
qmake "INCLUDEPATH+=C:\Program Files\MySQL\MySQL Server 5.0\include" "LIBS+=C:\Program Files\MySQL\MySQL Server 5.0\lib\opt\libmysql.lib" mysql.pro
make

(follow QTdocuments)

it appears me a very strange message :

...
In file included from main.cpp:44:
../../../sql/drivers/mysql/qsql_mysql.h:52:19: mysql.h: No such file or directory
In file included from main.cpp:44:
../../../sql/drivers/mysql/qsql_mysql.h:107: error: expected `)' before '*' token
make[1]: *** [debug/main.o] Error 1
make[1]: Leaving directory `C:/Qt/2009.02/qt/src/plugins/sqldrivers/mysql'
make: *** [debug] Error 2

What happends with me? Please help me.

Thanks.
Diego.

[Lykurg]

I am 99% sure that is is a problem with the space in your INCLUDEPATH path. On windows always errors occure because of spaces in the paths. So reinstall MySQL in e.g. c:\mysql

[diego]

Thanks Lykurg .

I have just re-installed Mysql

I run Qt Command Prompt to Build the QMYSQL Plugin on Windows.

cd %QTDIR%\src\plugins\sqldrivers\mysql
qmake "INCLUDEPATH+=C:\mysql\include" "LIBS+=C:\mysql\lib\opt\libmysql.lib" mysql.pro
make

It occurs to me a message :

C:/Qt/2009.02/qt/src/plugins/sqldrivers/mysql/../../../sql/drivers/mysql/qsql_my
sql.cpp:1419: undefined reference to `mysql_real_escape_string@16'
collect2: ld returned 1 exit status
make[1]: *** [debug\qsqlmysqld4.dll] Error 1
make[1]: Leaving directory `C:/Qt/2009.02/qt/src/plugins/sqldrivers/mysql'
make: *** [debug] Error 2

Please help me.

Thanks.
Diego

[gerhard]

We seem to be experiencing the same problem.

My company is currently experimenting with Qt for a future development strategy.

This issue however has my bosses worried about Qt's ability to work with MySQL

Could someone please look into this issue, cause we've been in this loop for the past week without any solution.

Thanks in advance!

[grenkku]

Hello everyone!

I'm experiencing the same problem with my Qt and MySQL. Has anyone yet resolved this problem?

qmake works properly... And as suggested, I used qmake lines from the help files, but still the make does not work properly.
And the problem was:

make
...
%QTDIR//sqldrivers/mysql/qsql_mysql.h:107: error: expected `)' before '*' token
make: *** [main.o] Error 1

And the line 107 which the error message indicates has the following code:
..
explicit QMYSQLDriver(MYSQL *con, QObject * parent=0);
..

[viheaho]

I also ran into many problems while trying to compile driver. I solved the problem by downloading mingw-utils 0.3. Add it to PATH variable
Then few simple steps:

cd e:\MySQL\lib\opt

reimp -d libmysql.lib

dlltool -k --input-def libmysql.def --dllname libmysql.dll --output-lib E:\Qt\2010.02\mingw\lib\libmysql.a

reimp libmysql.lib

cd e:\Qt\2010.02\qt\src\plugins\sqldrivers\mysql

qmake "INCLUDEPATH+=E:\MySQL\include" "LIBS+=E:\MYSQL\lib\opt\libmysql.lib" mysql.pro

mingw32-make

NOTICE that reimp is used twice

[And_re]

I tried this solution and the solution in pdf in spanish but I still get these errors:
[cut]
tmp/obj/debug_shared/qsql_mysql.o:C:\Qt\qt\src\plugins\sqldrivers\mysql/../../..
/sql/drivers/mysql/qsql_mysql.cpp:1430: undefined reference to `mysql_query@8'
tmp/obj/debug_shared/qsql_mysql.o:C:\Qt\qt\src\plugins\sqldrivers\mysql/../../..
/sql/drivers/mysql/qsql_mysql.cpp:1447: undefined reference to `mysql_query@8'
tmp/obj/debug_shared/qsql_mysql.o:C:\Qt\qt\src\plugins\sqldrivers\mysql/../../..
/sql/drivers/mysql/qsql_mysql.cpp:1464: undefined reference to `mysql_query@8'
tmp/obj/debug_shared/qsql_mysql.o:C:\Qt\qt\src\plugins\sqldrivers\mysql/../../..
/sql/drivers/mysql/qsql_mysql.cpp:1490: undefined reference to `mysql_real_escap
e_string@16'
collect2: ld returned 1 exit status
mingw32-make[1]: *** [..\..\..\..\plugins\sqldrivers\qsqlmysqld4.dll] Error 1
mingw32-make[1]: Leaving directory `C:/Qt/qt/src/plugins/sqldrivers/mysql'
mingw32-make: *** [debug-all] Error 2

Windows 7 x64, Qt 4.6

[tinysoft]

i still have that errors too


i am using :
Windows 7 x86 Qt 4.6 MySQLServer 5.1

[Ma7moud El-Naggar]

i have this problem too
and i hope to find solution to this problem

[saa7_go]

This is how i build QMYSQL driver with MinGW/GCC.

1. create directory C:\mysql, C:\mysql\include, and C:\mysql\lib
2. copy mysql headers(*.h) to C:\mysql\include
3. copy libmysql.lib to C:\mysql\lib
4. use command prompt and change directory to C:\mysql\lib and run :
> reimp -d libmysql.lib
> dlltool -d libmysql.def -D libmysql.dll -l libmysql.a -k
5. change directory to mysql driver plugin(for example C:\Qt\2010.03\qt\src\plugins\sqldrivers\mysql) and run:
> qmake "INCLUDEPATH+=C:\mysql\include" "LIBS+=-LC:\mysql\lib -lmysql" mysql.pro
> mingw32-make all

[Ma7moud El-Naggar]

i get this problem
hared/main.o tmp/obj/debug_shared/qsql_mysql.o tmp/obj/debug_shared/moc_qsql_mys
ql.o -L"c:\Qt\2010.04\qt\lib" -L"c:\Qt\2010.04\qt\lib" tmp\obj\debug_shared\qsq
lmysqld_resource_res.o -LC:\mysql\lib -lmysql -lQtSqld4 -lQtCored4
c:/qt/2010.04/mingw/bin/../lib/gcc/mingw32/4.4.0/../../../../mingw32/bin/ld.exe:
cannot find -lmysql
collect2: ld returned 1 exit status
mingw32-make[1]: *** [..\..\..\..\plugins\sqldrivers\qsqlmysqld4.dll] Error 1
mingw32-make[1]: Leaving directory `C:/Qt/2010.04/qt/src/plugins/sqldrivers/mysq
l'
mingw32-make: *** [debug-all] Error 2

i get bored it have been about two weeks trying to build driver