mysql 5 connection

[spirit]

please, show content of configure.cache

[GuL]

where is this file?

Renan

[spirit]

in root of QTDIR folder, i.e. C:\Qt-4.4.0\configure.cache

[GuL]

I haven't found this file, but I found this one:

.qmake.cache

QMAKE_QT_VERSION_OVERRIDE = 4
OBJECTS_DIR = tmp\obj\debug_shared
MOC_DIR = tmp\moc\debug_shared
RCC_DIR = tmp\rcc\debug_shared
sql-plugins += odbc sqlite
styles += windows plastique cleanlooks windowsxp windowsvista motif cde
imageformat-plugins += gif tiff jpeg
CONFIG += dist-config large-config medium-config minimal-config small-config full-config build_all debug incremental create_prl link_prl depend_includepath QTDIR_build
QT_BUILD_PARTS = libs tools examples demos docs
QMAKESPEC = C:\utils\Qt\4.4.0\mkspecs\win32-msvc2003
ARCH = windows
QT_BUILD_TREE = C:\utils\Qt\4.4.0
QT_SOURCE_TREE = C:\utils\Qt\4.4.0
DEFINES *= QT_EDITION=QT_EDITION_DESKTOP
QMAKE_MOC = $$QT_BUILD_TREE\bin\moc.exe
QMAKE_UIC = $$QT_BUILD_TREE\bin\uic.exe
QMAKE_UIC3 = $$QT_BUILD_TREE\bin\uic3.exe
QMAKE_RCC = $$QT_BUILD_TREE\bin\rcc.exe
QMAKE_DUMPCPP = $$QT_BUILD_TREE\bin\dumpcpp.exe
QMAKE_INCDIR_QT = $$QT_BUILD_TREE\include
QMAKE_LIBDIR_QT = $$QT_BUILD_TREE\lib

[spirit]

you have only odbc sqlite plugins installed, I don't see mysql driver.

[GuL]

So how do I install it?

Renan

[GuL]

Anybody has any ideia why using a commercial version of QT, I got this error?

QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QODBC3 QODBC QPSQL7 QPSQL

Renan

[spirit]

you set wrong QMAKESPEC, your QMAKESPEC=win32-msvc2003 but in you case (if you use 2005 VS) must be QMAKESPEC=win32-msvc2005

[GuL]

ok

I changed my QMAKESPEC, but I still get some errors:

Setting up a Qt environment...
-- QTDIR set to C:\utils\Qt\4.4.0
-- Added C:\utils\Qt\4.4.0\bin to PATH
-- QMAKESPEC set to "win32-msvc2005"
C:\utils\Qt\4.4.0>cd src\plugins\sqldrivers\mysql
 
C:\Utils\Qt\4.4.0\src\plugins\sqldrivers\mysql>qmake -o Makefile "INCLUDEPATH+=C:\Utils\MySQL5\include" "LIBS+=C:\Utils\MySQL5\lib
\opt\libmysql.lib" mysql.pro
 
C:\Utils\Qt\4.4.0\src\plugins\sqldrivers\mysql>nmake
 
Microsoft (R) Program Maintenance Utility Version 8.00.50727.762
Copyright (C) Microsoft Corporation.  All rights reserved.
 
        C:\Utils\MicrosoftVisualStudio8\SDK\v2.0\Bin\nmake.exe -f Makefile.Debug all
 
Microsoft (R) Program Maintenance Utility Version 8.00.50727.762
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_EDI
TION=QT_EDITION_DESKTOP -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_DLL -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -DQT_THREAD_
SUPPORT -I"c:\utils\Qt\4.4.0\include\QtCore" -I"c:\utils\Qt\4.4.0\include\QtCore" -I"c:\utils\Qt\4.4.0\include\QtSql" -I"c:\utils\
Qt\4.4.0\include\QtSql" -I"c:\utils\Qt\4.4.0\include" -I"c:\Utils\MySQL5\include" -I"c:\utils\Qt\4.4.0\include\ActiveQt" -I"tmp\mo
c\debug_shared" -I"." -I"c:\utils\Qt\4.4.0\mkspecs\win32-msvc2005" -Fotmp\obj\debug_shared\ @C:\DOCUME~1\Renan\CONFIG~1\Temp\nm13.
tmp
NMAKE : fatal error U1077: 'C:\Utils\MicrosoftVisualStudio8\VC\bin\cl.EXE' : return code '0xc0000135'
Stop.
NMAKE : fatal error U1077: 'C:\Utils\MicrosoftVisualStudio8\SDK\v2.0\Bin\nmake.exe' : return code '0x2'
Stop.
 
C:\Utils\Qt\4.4.0\src\plugins\sqldrivers\mysql>

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

C:\Utils\Qt\4.4.0\src\plugins\sqldrivers\mysql>qmake -o Makefile "INCLUDEPATH+=C:\Utils\MySQL5\include" "LIBS+=C:\Utils\MySQL5\lib
\opt\libmysql.lib" mysql.pro

C:\Utils\Qt\4.4.0\src\plugins\sqldrivers\mysql>nmake

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

        C:\Utils\MicrosoftVisualStudio8\SDK\v2.0\Bin\nmake.exe -f Makefile.Debug all

Microsoft (R) Program Maintenance Utility Version 8.00.50727.762
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_EDI
TION=QT_EDITION_DESKTOP -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_DLL -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -DQT_THREAD_
SUPPORT -I"c:\utils\Qt\4.4.0\include\QtCore" -I"c:\utils\Qt\4.4.0\include\QtCore" -I"c:\utils\Qt\4.4.0\include\QtSql" -I"c:\utils\
Qt\4.4.0\include\QtSql" -I"c:\utils\Qt\4.4.0\include" -I"c:\Utils\MySQL5\include" -I"c:\utils\Qt\4.4.0\include\ActiveQt" -I"tmp\mo
c\debug_shared" -I"." -I"c:\utils\Qt\4.4.0\mkspecs\win32-msvc2005" -Fotmp\obj\debug_shared\ @C:\DOCUME~1\Renan\CONFIG~1\Temp\nm13.
tmp
NMAKE : fatal error U1077: 'C:\Utils\MicrosoftVisualStudio8\VC\bin\cl.EXE' : return code '0xc0000135'
Stop.
NMAKE : fatal error U1077: 'C:\Utils\MicrosoftVisualStudio8\SDK\v2.0\Bin\nmake.exe' : return code '0x2'
Stop.

C:\Utils\Qt\4.4.0\src\plugins\sqldrivers\mysql>

To copy to clipboard, switch view to plain text mode 

Renan

[spirit]

did you try to build some application from examples?
were they built normally?

[GuL]

From the examples that came from QT, no. But I was folloing a tutorial to learn QT

http://maven.smith.edu/~thiebaut/tutorials/

And the have compiled fine. This is the first Im trying to connect to a database.

Renan

[GuL]

Thats interesting: I was with this problem the whole week, and now it worked.

Here is what I did: uninstall MySQL, QT and QT VS Integration. Restart the computer, and then install them all again.

This should do the job. I don't know why this had done it work, but it did. Maybe there is a bug somewhere. I don't know.

Thanks to all that tryied to help.

Renan

[ghoust26]

Thats interesting: I was with this problem the whole week, and now it worked.

Here is what I did: uninstall MySQL, QT and QT VS Integration. Restart the computer, and then install them all again.

This should do the job. I don't know why this had done it work, but it did. Maybe there is a bug somewhere. I don't know.

Thanks to all that tryied to help.

Renan

Should it be done in some specific order?