mysql 5 connection

[jpn]

You don't seem to have the MySQL plugin. See How to Build the QMYSQL Plugin on Windows.

[GuL]

But it shouldn't be instaled by default with a commercial version of qt?

[jpn]

One would assume so, but I don't remember for sure. Which files do you have in %QTDIR%\plugins\sqldrivers?

[fnmblot]

Don't forget to put the QT+= sql in your project file

[GuL]

23/04/2008  18:54           372.736 qsqlite4.dll
23/04/2008  18:54             2.062 qsqlite4.lib
23/04/2008  18:54           561.152 qsqlited4.dll
23/04/2008  18:54             2.074 qsqlited4.lib
23/04/2008  19:35            65.536 qsqlmysql4.dll
23/04/2008  19:35             2.088 qsqlmysql4.lib
23/04/2008  19:35           135.168 qsqlmysqld4.dll
23/04/2008  19:35             2.100 qsqlmysqld4.lib
23/04/2008  18:54            86.016 qsqlodbc4.dll
23/04/2008  18:54             2.074 qsqlodbc4.lib
23/04/2008  18:54           159.744 qsqlodbcd4.dll
23/04/2008  18:54             2.088 qsqlodbcd4.lib
23/04/2008  19:36           126.976 qsqlpsql4.dll
23/04/2008  19:36             2.074 qsqlpsql4.lib
23/04/2008  19:36           245.760 qsqlpsqld4.dll
23/04/2008  19:36             2.088 qsqlpsqld4.lib

23/04/2008  18:54           372.736 qsqlite4.dll
23/04/2008  18:54             2.062 qsqlite4.lib
23/04/2008  18:54           561.152 qsqlited4.dll
23/04/2008  18:54             2.074 qsqlited4.lib
23/04/2008  19:35            65.536 qsqlmysql4.dll
23/04/2008  19:35             2.088 qsqlmysql4.lib
23/04/2008  19:35           135.168 qsqlmysqld4.dll
23/04/2008  19:35             2.100 qsqlmysqld4.lib
23/04/2008  18:54            86.016 qsqlodbc4.dll
23/04/2008  18:54             2.074 qsqlodbc4.lib
23/04/2008  18:54           159.744 qsqlodbcd4.dll
23/04/2008  18:54             2.088 qsqlodbcd4.lib
23/04/2008  19:36           126.976 qsqlpsql4.dll
23/04/2008  19:36             2.074 qsqlpsql4.lib
23/04/2008  19:36           245.760 qsqlpsqld4.dll
23/04/2008  19:36             2.088 qsqlpsqld4.lib

To copy to clipboard, switch view to plain text mode 

Those are the files.

[jpn]

Ok so it is there. What if you open qsqlmysql4.dll to dependency walker. Can you see any missing dependencies?

[GuL]

Well, here is what Dependency Walker has found:

Error: At least one required implicit or forwarded dependency was not found.
Warning: At least one delay-load dependency module was not found.
Warning: At least one module has an unresolved import due to a missing export function in a delay-load dependent module.

LIBMYSQL.DLL and
MSJAVA.DLL


At least LIBMYSQL.DLL I know I have... But where should they be placed?

Renan

[spirit]

you can put path to mysql directory in PATH variable.
for example:

set PATH=C:\mysql\bin;%PATH%

[GuL]

libmysql.dll is in my PATH now. Im trying to find MSJAVA.DLL now.

Renan

[jpn]

libmysql.dll is in my PATH now. Im trying to find MSJAVA.DLL now.

Renan

The libmysql.dll should be enough. msjava.dll can be safely ignored, see dependency walker faq for more details.

[GuL]

Here is the output window in VS2005:

'testeMYSQL1.exe': Loaded 'C:\Documents and Settings\Renan\Meus documentos\Visual Studio 2005\Projects\testeMYSQL1\debug\testeMYSQL1.exe', Symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\ntdll.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\kernel32.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\Utils\Qt\4.4.0\bin\QtCored4.dll', Symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\user32.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\gdi32.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\ole32.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\advapi32.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\rpcrt4.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\secur32.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\msvcrt.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\ws2_32.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\ws2help.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\msvcp71d.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\msvcr71d.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\Utils\Qt\4.4.0\bin\QtGuid4.dll', Symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\comdlg32.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\shlwapi.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\comctl32.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\shell32.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\oleaut32.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\imm32.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\winmm.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\winspool.drv', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\Utils\Qt\4.4.0\bin\QtSqld4.dll', Symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\WinSxS\x86_Microsoft.VC80.DebugCRT_1fc 8b3b9a1e18e3b_8.0.50727.762_x-ww_5490cd9f\msvcr80d.dll', Symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\WinSxS\x86_Microsoft.VC80.DebugCRT_1fc 8b3b9a1e18e3b_8.0.50727.762_x-ww_5490cd9f\msvcp80d.dll', Symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\avgrsstx.dll', No symbols loaded.
'testeMYSQL1.exe': Unloaded 'C:\WINDOWS\system32\avgrsstx.dll'
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.2982_x-ww_ac3f9c03\comctl32.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\uxtheme.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\xpsp2res.dll', Binary was not built with debug information.
The thread 'Win32 Thread' (0xa9c) has exited with code 0 (0x0).
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QODBC3 QODBC QPSQL7 QPSQL
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\wdmaud.drv', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\setupapi.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\wintrust.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\crypt32.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\msasn1.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\imagehlp.dll', No symbols loaded.
'testeMYSQL1.exe': Unloaded 'C:\WINDOWS\system32\setupapi.dll'
'testeMYSQL1.exe': Unloaded 'C:\WINDOWS\system32\wdmaud.drv'
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\wdmaud.drv', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\setupapi.dll', No symbols loaded.
'testeMYSQL1.exe': Unloaded 'C:\WINDOWS\system32\setupapi.dll'
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\msacm32.drv', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\msacm32.dll', No symbols loaded.
'testeMYSQL1.exe': Loaded 'C:\WINDOWS\system32\midimap.dll', No symbols loaded.
The thread 'Win32 Thread' (0xb2c) has exited with code 0 (0x0).


Still no success.

[jpn]

Did you restart Visual Studio after modifying PATH? It needs to be restarted in order for it to pick the new environment.

[GuL]

Yes, I had to do it with Dependency Walker too.

Renan

[spirit]

try to rebuild mysql plugin.

[spirit]

You don't seem to have the MySQL plugin. See How to Build the QMYSQL Plugin on Windows.

use this post

[GuL]

C:\Utils\Qt\4.4.0\src\plugins\sqldrivers>qmake -o Makefile "INCLUDEPATH+=C:\Utils\MySQL5\include" "LIBS+=C:\Utils\MySQL5\lib\opt\l
ibmysql.dll" mysql.pro
Cannot find file: mysql.pro.


Renan

[spirit]

libmysql.lib don't dll
worng path, it should be like this

cd %QTDIR%\src\plugins\sqldrivers\mysql

[GuL]

another error:

C:\Utils\Qt\4.4.0\src\plugins\sqldrivers\mysql>qma ke -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>nma ke

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.

rc -D_DEBUG -DUNICODE -DWIN32 -DQT_LARGEFILE_SUPPORT -DQT_EDITION=QT_EDITION_DESKTOP -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FR
OM_ASCII -DQT_DLL -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -DQT_THREAD_SUPPORT -fo tmp\obj\debug_shared\qsqlmysqld_resource.res qsql
mysqld_resource.rc
qsqlmysqld_resource.rc(4) : fatal error RC1015: cannot open include file 'winver.h'.
NMAKE : fatal error U1077: 'C:\Utils\MicrosoftVisualStudio8\SDK\v2.0\Bin\rc.E XE' : return code '0x1'
Stop.
NMAKE : fatal error U1077: 'C:\Utils\MicrosoftVisualStudio8\SDK\v2.0\Bin\nmak e.exe' : return code '0x2'
Stop.

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

[spirit]

did you set INCLUDE & LIB for VS?

[GuL]

here is my PATH, if thats what you are asking:

PATH

%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\sy stem32\WBEM;C:\Utils\python25\;C:\Utils\Qt\4.4.0\b in;C:\Utils\MicrosoftVisualStudio8\SDK\v2.0\Bin;C: \Utils\MicrosoftVisualStudio8\VC\bin;C:\Utils\Micr osoftVisualStudio8\VC;C:\Utils\MySQL5\bin

Renan