Problem Wtih Connecting MySQL Database on Windows

[dummystories]

Hi to all,


I am developing an application using Qt and my database is MySQL on windows. I gone through SQL Database Driver in Qt Assistance provided by Trolltech. Here i found that i need to create plugin for MySQL.

I followed the instructions provided in the Qt Assistance as follows:


cd %QTDIR%\src\plugins\sqldrivers\mysql
qmake -o Makefile "INCLUDEPATH+=C:\MySQL\include" "LIBS+=C:\MySQL\lib\opt\libmysql.lib" mysql.pro
nmake

I am getting the following error:

C:\Qt\4.3.4\src\plugins\sqldrivers\mysql>nmake
'nmake' is not recognized as an internal or external command,
operable program or batch file.

Can any one resolve my problem

Waiting for your reply.

Regards,

Narasimha Raju. Naidu

[spirit]

open VS command prompt and run these commands again.
the command prompt is located Start->All programms->Microsoft Studio Visual Studio->Visual Studio Tools.

[dummystories]

Thanks for your reply.

I am using MingW and i tried to compile and i am getting the following error.

C:\Qt\4.3.4\src\plugins\sqldrivers\mysql>qmake -o Makefile "INCLUDEPATH+=C:\prog
ra~1\MySQL\include" "LIBS+=C:\progra~1\lib\opt\libmysql.lib" mysql.pro
 
C:\Qt\4.3.4\src\plugins\sqldrivers\mysql>mingw32-make
mingw32-make -f Makefile.Release
mingw32-make[1]: Entering directory `C:/Qt/4.3.4/src/plugins/sqldrivers/mysql'
g++ -c -O2 -frtti -fexceptions -mthreads -Wall -DUNICODE -DQT_LARGEFILE_SUPPORT
-DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_DLL -DQT_NO_DEBUG -DQT_PLUGIN
 -DQT_SQL_LIB -DQT_CORE_LIB -DQT_THREAD_SUPPORT -I"..\..\..\..\include\QtCore" -
I"..\..\..\..\include\QtCore" -I"..\..\..\..\include\QtSql" -I"..\..\..\..\inclu
de\QtSql" -I"..\..\..\..\include" -I"c:\progra~1\MySQL\include" -I"c:\Qt\4.3.4\i
nclude\ActiveQt" -I"tmp\moc\release_shared" -I"." -I"..\..\..\..\mkspecs\win32-g
++" -o tmp\obj\release_shared\main.o main.cpp
In file included from main.cpp:46:
../../../sql/drivers/mysql/qsql_mysql.h:54:19: mysql.h: No such file or director
y
In file included from main.cpp:46:
../../../sql/drivers/mysql/qsql_mysql.h:105: error: expected `)' before '*' toke
n
mingw32-make[1]: *** [tmp/obj/release_shared/main.o] Error 1
mingw32-make[1]: Leaving directory `C:/Qt/4.3.4/src/plugins/sqldrivers/mysql'
mingw32-make: *** [release] Error 2

C:\Qt\4.3.4\src\plugins\sqldrivers\mysql>qmake -o Makefile "INCLUDEPATH+=C:\prog
ra~1\MySQL\include" "LIBS+=C:\progra~1\lib\opt\libmysql.lib" mysql.pro

C:\Qt\4.3.4\src\plugins\sqldrivers\mysql>mingw32-make
mingw32-make -f Makefile.Release
mingw32-make[1]: Entering directory `C:/Qt/4.3.4/src/plugins/sqldrivers/mysql'
g++ -c -O2 -frtti -fexceptions -mthreads -Wall -DUNICODE -DQT_LARGEFILE_SUPPORT
-DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_DLL -DQT_NO_DEBUG -DQT_PLUGIN
 -DQT_SQL_LIB -DQT_CORE_LIB -DQT_THREAD_SUPPORT -I"..\..\..\..\include\QtCore" -
I"..\..\..\..\include\QtCore" -I"..\..\..\..\include\QtSql" -I"..\..\..\..\inclu
de\QtSql" -I"..\..\..\..\include" -I"c:\progra~1\MySQL\include" -I"c:\Qt\4.3.4\i
nclude\ActiveQt" -I"tmp\moc\release_shared" -I"." -I"..\..\..\..\mkspecs\win32-g
++" -o tmp\obj\release_shared\main.o main.cpp
In file included from main.cpp:46:
../../../sql/drivers/mysql/qsql_mysql.h:54:19: mysql.h: No such file or director
y
In file included from main.cpp:46:
../../../sql/drivers/mysql/qsql_mysql.h:105: error: expected `)' before '*' toke
n
mingw32-make[1]: *** [tmp/obj/release_shared/main.o] Error 1
mingw32-make[1]: Leaving directory `C:/Qt/4.3.4/src/plugins/sqldrivers/mysql'
mingw32-make: *** [release] Error 2

To copy to clipboard, switch view to plain text mode 

can you help me out.

Regards,

Narasimha Raju. Naidu

[spirit]

you have to create a static lib of MySQL which MinGW can recognize.
read this how to do this. when you will create a static lib for MinGW then repeat your steps again.

[dummystories]

Thanks for your reply

I gone through the instructions and downloaded impdef, copied in to C:\MingW\bin. Then i executed the following command and i got the following error.

C:\MinGW\bin>dlltool --dllname libmysql.dll --def libmysql.def --output-lib libm
ysql.a
dlltool: Can't open def file: libmysql.def
 
C:\MinGW\bin>

C:\MinGW\bin>dlltool --dllname libmysql.dll --def libmysql.def --output-lib libm
ysql.a
dlltool: Can't open def file: libmysql.def

C:\MinGW\bin>

To copy to clipboard, switch view to plain text mode 

Waiting for your reply

Regards,

Narasimha Raju.Naidu

[spirit]

use this tool.

[dummystories]

Thanks for your reply.

I downloaded the file and extracted at C:\MinGW\bin. and executed the command but still i am getting the same error.


Regards,

Narasimha Raju. Naidu

[spirit]

did you rename a file in archive from impdef_tar to impdef.tar?
did you create libmysql.def using impdef libmysql.dll > libmysql.def?

[dummystories]

Thanks for your reply,

I successfully created libmysql.def file. what should i do now. Where should i keep this file. Right now this file is at C:\MinGW\bin.

Waiting for your reply

Regards,

Narasimha Raju. Naidu

[spirit]

1. navigate to MYSQLDIR\lib\opt

cd MYSQLDIR\lib\opt

2. impdef libmysql.dll > libmysql.def
3. dlltool --dllname libmysql.dll --def libmysql.def --output-lib libmysql.a
4. navigate to QTDIR\src\plugins\sqldrivers\mysql

cd %QTDIR%\src\plugins\sqldrivers\mysql
qmake "INCLUDEPATH+=MYSQLDIR\include" "LIBS+=MYSQLDIR\lib\opt\libmysql.a" mysql.pro
mingw32-make

[dummystories]

Thanks for your reply,

According to your instructions i navigated my current directory to mysqldir\lib\opt
and tried to compile and i got the following error


C:\PROGRA~1\MySQL\MySQL Server 5.0\lib\opt>dlltool --dllname libmysql.dll --def
libmysql.def --output-lib libmysql.a
'dlltool' is not recognized as an internal or external command,
operable program or batch file.

i set path for environment varibales for C:\MingW\bin. still i am getting the same error.

What should i do now.

I am waiting for your reply.

Regards,

Narasimha Raju. Naidu