July 12, 2011

dukaim dukaim
Lab Rat
2 posts

mySQL Driver Problems (Solved it)

 

Hello, I’ve been trying to install the mySQL driver (Windows 7) and its been a headache. It was so easy to install in Ubuntu :(

Anyways, after using this guide [pikopong.com]

The commands for the QT Command Propmt “worked” but when I test the drivers in my application I only get

  1. int main(int argc, char *argv[])
  2. {
  3.     QCoreApplication a(argc, argv);
  4.     qDebug() << QSqlDatabase::drivers();
  5.     return a.exec();
  6. }

  1. <"QSQLITE", "QODBC3", "QODBC">

Here are my commands:

  1. Setting up a MinGW/Qt only environment...
  2. -- QTDIR set to C:\Qt\2010.05\qt
  3. -- PATH set to C:\Qt\2010.05\qt\bin
  4. -- Adding C:\Qt\2010.05\bin to PATH
  5. -- Adding C:\Windows\System32 to PATH
  6. -- QMAKESPEC set to win32-g++
  7.  
  8. C:\Windows\system32>set mySQLDIR=c:\mySQL
  9.  
  10. C:\Windows\system32>cd %QTDIR%\src\plugins\sqldrivers\mysql
  11.  
  12. C:\Qt\2010.05\qt\src\plugins\sqldrivers\mysql>qmake "INCLUDEPATH+=%mySQLDIR%\inc
  13. lude" "LIBS+=%mySQLDIR%\lib\libmysql.lib" -o Makefile mysql.pro
  14. WARNING: (internal):1: Unescaped backslashes are deprecated.
  15. WARNING: (internal):1: Unescaped backslashes are deprecated.
  16. WARNING: (internal):1: Unescaped backslashes are deprecated.
  17.  
  18. C:\Qt\2010.05\qt\src\plugins\sqldrivers\mysql>mingw32-make
  19. mingw32-make -f Makefile.Debug all
  20. mingw32-make[1]: Entering directory `C:/Qt/2010.05/qt/src/plugins/sqldrivers/mys
  21. ql'
  22. g++ -enable-stdcall-fixup -Wl,-enable-auto-import -Wl,-enable-runtime-pseudo-rel
  23. oc -mthreads -Wl -shared -Wl,--out-implib,c:\Qt\2010.05\qt\plugins\sqldrivers\li
  24. bqsqlmysqld4.a -o ..\..\..\..\plugins\sqldrivers\qsqlmysqld4.dll tmp/obj/debug_s
  25. hared/main.o tmp/obj/debug_shared/qsql_mysql.o tmp/obj/debug_shared/moc_qsql_mys
  26. ql.o  -L"c:\Qt\2010.05\qt\lib" -L"c:\Qt\2010.05\qt\lib" tmp\obj\debug_shared\qsq
  27. lmysqld_resource_res.o c:\mySQL\lib\libmysql.lib -lQtSqld4 -lQtCored4
  28. Creating library file: c:\Qt\2010.05\qt\plugins\sqldrivers\libqsqlmysqld4.a
  29. mingw32-make[1]: Leaving directory `C:/Qt/2010.05/qt/src/plugins/sqldrivers/mysq
  30. l'
  31. mingw32-make -f Makefile.Release all
  32. mingw32-make[1]: Entering directory `C:/Qt/2010.05/qt/src/plugins/sqldrivers/mys
  33. ql'
  34. g++ -c -O2 -frtti -fexceptions -mthreads -Wall -DUNICODE -DQT_LARGEFILE_SUPPORT
  35. -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_DLL -DQT_NO_DEBUG -DQT_PLUGIN
  36. -DQT_SQL_LIB -DQT_CORE_LIB -DQT_THREAD_SUPPORT -I"..\..\..\..\include\QtCore" -
  37. I"..\..\..\..\include\QtSql" -I"..\..\..\..\include" -I"c:\mySQL\include" -I"..\
  38. ..\..\..\include\ActiveQt" -I"tmp\moc\release_shared" -I"..\..\..\..\mkspecs\win
  39. 32-g++" -o tmp\obj\release_shared\main.o main.cpp
  40. C:\Qt\2010.05\qt\bin\moc.exe -DUNICODE -DQT_LARGEFILE_SUPPORT -DQT_NO_CAST_TO_AS
  41. CII -DQT_NO_CAST_FROM_ASCII -DQT_DLL -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT
  42. _CORE_LIB -DQT_THREAD_SUPPORT -I"..\..\..\..\include\QtCore" -I"..\..\..\..\incl
  43. ude\QtSql" -I"..\..\..\..\include" -I"c:\mySQL\include" -I"..\..\..\..\include\A
  44. ctiveQt" -I"tmp\moc\release_shared" -I"..\..\..\..\mkspecs\win32-g++" -D__GNUC__
  45. -DWIN32 ..\..\..\sql\drivers\mysql\qsql_mysql.cpp -o tmp\moc\release_shared\qsq
  46. l_mysql.moc
  47. g++ -c -O2 -frtti -fexceptions -mthreads -Wall -DUNICODE -DQT_LARGEFILE_SUPPORT
  48. -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_DLL -DQT_NO_DEBUG -DQT_PLUGIN
  49. -DQT_SQL_LIB -DQT_CORE_LIB -DQT_THREAD_SUPPORT -I"..\..\..\..\include\QtCore" -
  50. I"..\..\..\..\include\QtSql" -I"..\..\..\..\include" -I"c:\mySQL\include" -I"..\
  51. ..\..\..\include\ActiveQt" -I"tmp\moc\release_shared" -I"..\..\..\..\mkspecs\win
  52. 32-g++" -o tmp\obj\release_shared\qsql_mysql.o ..\..\..\sql\drivers\mysql\qsql_m
  53. ysql.cpp
  54. C:\Qt\2010.05\qt\bin\moc.exe -DUNICODE -DQT_LARGEFILE_SUPPORT -DQT_NO_CAST_TO_AS
  55. CII -DQT_NO_CAST_FROM_ASCII -DQT_DLL -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT
  56. _CORE_LIB -DQT_THREAD_SUPPORT -I"..\..\..\..\include\QtCore" -I"..\..\..\..\incl
  57. ude\QtSql" -I"..\..\..\..\include" -I"c:\mySQL\include" -I"..\..\..\..\include\A
  58. ctiveQt" -I"tmp\moc\release_shared" -I"..\..\..\..\mkspecs\win32-g++" -D__GNUC__
  59. -DWIN32 ..\..\..\sql\drivers\mysql\qsql_mysql.h -o tmp\moc\release_shared\moc_q
  60. sql_mysql.cpp
  61. g++ -c -O2 -frtti -fexceptions -mthreads -Wall -DUNICODE -DQT_LARGEFILE_SUPPORT
  62. -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_DLL -DQT_NO_DEBUG -DQT_PLUGIN
  63. -DQT_SQL_LIB -DQT_CORE_LIB -DQT_THREAD_SUPPORT -I"..\..\..\..\include\QtCore" -
  64. I"..\..\..\..\include\QtSql" -I"..\..\..\..\include" -I"c:\mySQL\include" -I"..\
  65. ..\..\..\include\ActiveQt" -I"tmp\moc\release_shared" -I"..\..\..\..\mkspecs\win
  66. 32-g++" -o tmp\obj\release_shared\moc_qsql_mysql.o tmp\moc\release_shared\moc_qs
  67. ql_mysql.cpp
  68. windres -i qsqlmysql_resource.rc -o tmp\obj\release_shared\qsqlmysql_resource_re
  69. s.o --include-dir=. -DUNICODE -DQT_LARGEFILE_SUPPORT -DQT_NO_CAST_TO_ASCII -DQT_
  70. NO_CAST_FROM_ASCII -DQT_DLL -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB
  71. -DQT_THREAD_SUPPORT
  72. g++ -enable-stdcall-fixup -Wl,-enable-auto-import -Wl,-enable-runtime-pseudo-rel
  73. oc -Wl,-s -mthreads -Wl -shared -Wl,--out-implib,c:\Qt\2010.05\qt\plugins\sqldri
  74. vers\libqsqlmysql4.a -o ..\..\..\..\plugins\sqldrivers\qsqlmysql4.dll tmp/obj/re
  75. lease_shared/main.o tmp/obj/release_shared/qsql_mysql.o tmp/obj/release_shared/m
  76. oc_qsql_mysql.o  -L"c:\Qt\2010.05\qt\lib" -L"c:\Qt\2010.05\qt\lib" tmp\obj\relea
  77. se_shared\qsqlmysql_resource_res.o c:\mySQL\lib\libmysql.lib -lQtSql4 -lQtCore4
  78.  
  79. Creating library file: c:\Qt\2010.05\qt\plugins\sqldrivers\libqsqlmysql4.a
  80. mingw32-make[1]: Leaving directory `C:/Qt/2010.05/qt/src/plugins/sqldrivers/mysq
  81. l'
  82.  
  83. C:\Qt\2010.05\qt\src\plugins\sqldrivers\mysql>

Thanks in advanced, Dukaim

2 replies

July 12, 2011

dukaim dukaim
Lab Rat
2 posts

Solved it my copying the libmysql.dll from the mySQL directory to C:\Windows if anyone is having the same problem.

Thanks tho. :D

July 12, 2011

peppe peppe
Ant Farmer
1025 posts
  • Qt DevNet Moderator
  • Certified Specialist

That sounds like a terrible idea. Just copy the dll in the very directory of the application you’re building, or put it in a safe place in PATH (like the qt/bin subdir of the SDK).

 Signature 

Software Engineer
KDAB (UK) Ltd., a KDAB Group company

 
  ‹‹ Static build on Cygwin with Qt3      Qt 4.7.3 build on Cygwin ››

You must log in to post a reply. Not a member yet? Register here!

 
Selected by the fine Qt Content Robot based on tags and ratings.

Possibly related content

Forum posts and FAQ

© 2013 Qt Project Hosting. Qt® and the Qt logo is a registered trade mark of Digia plc and/or its subsidiaries and is used pursuant to a license from Digia plc and/or its subsidiaries.
All other trademarks are property of their respective owners. Privacy Policy
This site is hosted by Gitorious AS. Your use of this web site is governed by these terms of service.

Qt Project Hosting, P.O. Box 4332 Nydalen, 0402 Oslo, Norway. Org. Nr. 997 447 913