前一段时间又需要编译Qt的MySQL驱动,不过这次顺利的多,因为有过编译的经验,而且还找到了一篇步骤全面的文章,在此Mark一下以便以后需要。
一、开发环境:
二、编译mysql驱动程序的过程:
1、用mingw-utils包中的reimp命令生成 libmysql.a 文件。
2、编译mysql驱动:
三、编写了一个简单的SQL程序:
int main(int argc, char *argv[])
{
QApplication a(argc, argv);
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setDatabaseName("test");
db.setUserName("root");
db.setPassword("root");
bool ok = db.open();
std::cout << "db.open(): " << db.open() << std::endl;
}
四、解决办法:
重新运行程序,提示:
说明数据库已经连上。
参考links:
http://www.qtcn.org/bbs/read.php?tid=4210
http://linux.chinaunix.net/techdoc/database/2008/08/19/1026089.shtml
http://kenby.javaeye.com/blog/422708
操作日志:
Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.
D:\mysql41>cd D:\mysql41\lib\opt
D:\mysql41\lib\opt>D:\devProgram\Qt\mingw-utils-0.3\bin\reimp -d libmysql.lib
D:\mysql41\lib\opt>D:\devProgram\Qt\2009.03\mingw\bin\dlltool -k -d libmysql.def -l libmysql.a
D:\mysql41\lib\opt>cd D:\devProgram\Qt\2009.03\qt\src\plugins\sqldrivers\mysql
D:\devProgram\Qt\2009.03\qt\src\plugins\sqldrivers\mysql>qmake -o Makefile "INCLUDEPATH+=D:\mysql41\include" "LIBS+=D:\mysql41\lib\opt\libmysql.a" mysql.pro
D:\devProgram\Qt\2009.03\qt\src\plugins\sqldrivers\mysql>nmake
Microsoft (R) Program Maintenance Utility
Copyright (C) Microsoft Corp 1988-1998. All rights reserved.
Microsoft (R) Program Maintenance Utility
Copyright (C) Microsoft Corp 1988-1998. All rights reserved.
B -DQT_CORE_LIB -DQT_THREAD_SUPPORT -I"..\..\..\..\include\QtCore" -I"..\..\..\..\include\QtSql" -I"..\..\..\..\include" -I"d:\mysql41\include" -I"..\..\..\..\includ
e\ActiveQt" -I"debug" -I"..\..\..\..\mkspecs\default" -o debug\main.o main.cpp
'g++' 不是内部或外部命令,也不是可运行的程序
或批处理文件。
NMAKE : fatal error U1077: 'g++' : return code '0x1'
Stop.
NMAKE : fatal error U1077: '"D:\Microsoft Visual Studio\VC98\bin\NMAKE.EXE"' : return code '0x2'
Stop.
D:\devProgram\Qt\2009.03\qt\src\plugins\sqldrivers\mysql>mingw32-make.exe
mingw32-make.exe -f Makefile.Debug
mingw32-make.exe[1]: Entering directory `D:/devProgram/Qt/2009.03/qt/src/plugins/sqldrivers/mysql'
g++ -c -g -frtti -fexceptions -mthreads -Wall -DUNICODE -DQT_LARGEFILE_SUPPORT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_DLL -DQT_PLUGIN -DQT_SQL_LIB -DQT_C
ORE_LIB -DQT_THREAD_SUPPORT -I"..\..\..\..\include\QtCore" -I"..\..\..\..\include\QtSql" -I"..\..\..\..\include" -I"d:\mysql41\include" -I"..\..\..\..\include\Active
Qt" -I"debug" -I"..\..\..\..\mkspecs\default" -o debug\main.o main.cpp
D:/devProgram/Qt/2009.03/qt/bin\moc.exe -DUNICODE -DQT_LARGEFILE_SUPPORT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_DLL -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LI
B -DQT_THREAD_SUPPORT -I"..\..\..\..\include\QtCore" -I"..\..\..\..\include\QtSql" -I"..\..\..\..\include" -I"d:\mysql41\include" -I"..\..\..\..\include\ActiveQt" -I
"debug" -I"..\..\..\..\mkspecs\default" -D__GNUC__ -DWIN32 ..\..\..\sql\drivers\mysql\qsql_mysql.cpp -o debug\qsql_mysql.moc
g++ -c -g -frtti -fexceptions -mthreads -Wall -DUNICODE -DQT_LARGEFILE_SUPPORT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_DLL -DQT_PLUGIN -DQT_SQL_LIB -DQT_C
ORE_LIB -DQT_THREAD_SUPPORT -I"..\..\..\..\include\QtCore" -I"..\..\..\..\include\QtSql" -I"..\..\..\..\include" -I"d:\mysql41\include" -I"..\..\..\..\include\Active
Qt" -I"debug" -I"..\..\..\..\mkspecs\default" -o debug\qsql_mysql.o ..\..\..\sql\drivers\mysql\qsql_mysql.cpp
In file included from ..\..\..\sql\drivers\mysql\qsql_mysql.cpp:1476:
debug/qsql_mysql.moc:72:26: warning: no newline at end of file
D:/devProgram/Qt/2009.03/qt/bin\moc.exe -DUNICODE -DQT_LARGEFILE_SUPPORT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_DLL -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LI
B -DQT_THREAD_SUPPORT -I"..\..\..\..\include\QtCore" -I"..\..\..\..\include\QtSql" -I"..\..\..\..\include" -I"d:\mysql41\include" -I"..\..\..\..\include\ActiveQt" -I
"debug" -I"..\..\..\..\mkspecs\default" -D__GNUC__ -DWIN32 ..\..\..\sql\drivers\mysql\qsql_mysql.h -o debug\moc_qsql_mysql.cpp
g++ -c -g -frtti -fexceptions -mthreads -Wall -DUNICODE -DQT_LARGEFILE_SUPPORT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_DLL -DQT_PLUGIN -DQT_SQL_LIB -DQT_C
ORE_LIB -DQT_THREAD_SUPPORT -I"..\..\..\..\include\QtCore" -I"..\..\..\..\include\QtSql" -I"..\..\..\..\include" -I"d:\mysql41\include" -I"..\..\..\..\include\Active
Qt" -I"debug" -I"..\..\..\..\mkspecs\default" -o debug\moc_qsql_mysql.o debug\moc_qsql_mysql.cpp
windres -i qsqlmysqld_resource.rc -o debug\qsqlmysqld_resource_res.o --include-dir=.
g++ -enable-stdcall-fixup -Wl,-enable-auto-import -Wl,-enable-runtime-pseudo-reloc -mthreads -Wl -shared -Wl,--out-implib,debug\libqsqlmysqld4.a -o debug\qsqlmysqld4
.dll debug/main.o debug/qsql_mysql.o debug/moc_qsql_mysql.o
ld4 -lQtCored4
Creating library file: debug\libqsqlmysqld4.a
mingw32-make.exe[1]: Leaving directory `D:/devProgram/Qt/2009.03/qt/src/plugins/sqldrivers/mysql'
D:\devProgram\Qt\2009.03\qt\src\plugins\sqldrivers\mysql>