Please, guys, share mysql driver

[Ryumaster]

Hi there! I really am desperate now, I've tried to build it myself for the last 48h. I managed to build up mysql driver using wingw32, but it was not compatible with Visual Studio. As for Visual Studio, I stuck with stupid U1077 nmake error, which tells me nothign about its nature.

PLEASE, SOMEONE!

May you share 4.7.4 mysql driver (lib+dll) for visual studio?
I can't take it anymore, guess I'm out of luck this week.

[ChrisW67]

As for Visual Studio, I stuck with stupid U1077 nmake error, which tells me nothign about its nature.

The error message is fairly self-explanatory:

NMAKE Fatal Error U1007
Visual Studio 2010
double quotation mark not allowed in name

The specified target name or filename contained a double quotation mark (").

Double quotation marks can surround a filename but cannot be contained within it.

It could be something as simple as placing MySQL in a directory path containing spaces, and something not handling the quotes needed in that circumstance. It would probably be fairly obvious if you shared the actual linker command line that triggered the error, and the commands you executed.

[Ryumaster]

But I do not have any empty spaces, I maked sure, I even changed "TEMP" path to point to some simple C:\temp folder.

Setting up a Qt environment...
-- QTDIR set to C:\Qt\4.7.4
-- Added C:\Qt\4.7.4\bin to PATH
-- QMAKESPEC set to "win32-msvc2008"
C:\Qt\4.7.4>cd C:\Qt\4.7.4\src\plugins\sqldrivers\mysql

C:\Qt\4.7.4\src\plugins\sqldrivers\mysql>nmake

Microsoft (R) Program Maintenance Utility Version 9.00.30729.01
Copyright (C) Microsoft Corporation. All rights reserved.

"C:\Program Files (x86)\Microsoft Visual Studio 9.0\VC\bin\nmake.exe" -f
Makefile.Debug

Microsoft (R) Program Maintenance Utility Version 9.00.30729.01
Copyright (C) Microsoft Corporation. All rights reserved.

cl -c -nologo -Zm200 -Zc:wchar_t- -Zi -MDd -GR -EHsc -W3 -w34100 -w34189
-DUNICODE -DWIN32 -DQT_LARGEFILE_SUPPORT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FRO
M_ASCII -DQT_DLL -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -DQT_HAVE_MMX -DQT_HAVE_
3DNOW -DQT_HAVE_SSE -DQT_HAVE_MMXEXT -DQT_HAVE_SSE2 -DQT_THREAD_SUPPORT -I"..\..
\..\..\include\QtCore" -I"..\..\..\..\include\QtSql" -I"..\..\..\..\include" -I"
c:\MySQL\include" -I"..\..\..\..\include\ActiveQt" -I"debug" -I"..\..\..\..\mksp
ecs\win32-msvc2008" -Fodebug\ @C:\temp\nm10DB.tmp
NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual Studio 9.0\
VC\bin\cl.EXE"' : return code '0xc0000135'
Stop.
NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual Studio 9.0\
VC\bin\nmake.exe"' : return code '0x2'
Stop.

That is the output, but I can't make anything useful from it.

---

Added after 45 minutes:

I appreciate any help, but still, if someone has already compiled driver, please share it, so my struggle would end. meanwhile, I'll still be trying to build it myself, maybe I need to put nmake to other path, at standart contains spaces. But that is insane, hmm

[ChrisW67]

Are you running this from a command prompt that has the Microsoft compiler environment variables set?
Start the Qt command prompt then run:

"C:\Program Files (x86)\Microsoft Visual Studio 9.0\VC\bin\vcvars32.bat"
cd %QTDIR%\src\plugins\sqldrivers\mysql
qmake "INCLUDEPATH+=C:\MySQL\include" "LIBS+=C:\MYSQL\MySQL Server <version>\lib\opt\libmysql.lib" mysql.pro
nmake

"C:\Program Files (x86)\Microsoft Visual Studio 9.0\VC\bin\vcvars32.bat"
cd %QTDIR%\src\plugins\sqldrivers\mysql
qmake "INCLUDEPATH+=C:\MySQL\include" "LIBS+=C:\MYSQL\MySQL Server <version>\lib\opt\libmysql.lib" mysql.pro
nmake

To copy to clipboard, switch view to plain text mode 

with appropriate adjustments for the location of your built MySQL (32-bit).

Edit: It may be vcvarsall.bat on your machine.

[Ryumaster]

Thanks a lot for trying to help! That is exactly how I did it, accroding to many tutorials on the web.

QT Command Prompt, and vs2008 variables are set, and I still end up with the error in my previous post. Now I tried to re-do it all again from scratch, no effects. I wonder, what else might it be? Oh jeez, I'm running out of time. Guess I need to start search for 3rd party mySQL classes hastly

---

Added after 1 3 minutes:

Phew, finally, it worked with VS 2010 Express compiler. Also, I had to add ;c:\windows\system32 into PATH.
Thanks again for the help, time to move forward!

[grayfox]

Why doesn't Qt provides a mysql driver in their binary distribution?
I was pretty surprise that I actually have to compile the driver by myself

[Lykurg]

Why doesn't Qt provides a mysql driver in their binary distribution?

I guess licensing limitations, but not sure on that.

[wysota]

Why doesn't Qt provides a mysql driver in their binary distribution?

If they did, you would come here and say "Why does Qt provide a MySQL driver that doesn't work?". And it wouldn't work because MySQL client library is required that is not part of Qt and is probably not compatible with Qt licencing scheme, as Lorenz suggests.