安装QT qt-opensource-windows-x86-msvc2015_64-5.6.0.exe,安装时注意源码也要一起安装,默认没有勾选源码
安装Oracle客户端或者instantclint sdk
安装完成后在 5.6\Src\qtbase\src\plugins\sqldrivers\oci 的oci.pro里添加以下内容
win32:CONFIG(release, debug|release): LIBS += -L$$PWD/../../../../../../../../../app/Administrator/product/11.2.0/client_1/oci/lib/msvc/ -loci
else:win32:CONFIG(debug, debug|release): LIBS += -L$$PWD/../../../../../../../../../app/Administrator/product/11.2.0/client_1/oci/lib/msvc/ -loci
else:unix: LIBS += -L$$PWD/../../../../../../../../../app/Administrator/product/11.2.0/client_1/oci/lib/msvc/ -loci
INCLUDEPATH += $$PWD/../../../../../../../../../app/Administrator/product/11.2.0/client_1/oci/lib/msvc
INCLUDEPATH += $$PWD/../../../../../../../../../app/Administrator/product/11.2.0/client_1/oci/include
DEPENDPATH += $$PWD/../../../../../../../../../app/Administrator/product/11.2.0/client_1/oci/lib/msvc$$PWD/../../../../../../../../../app/Administrator/product/11.2.0/client_1/oci 代表oracle客户端oci目录,或者instantclient sdk目录
然后打开oci.pro文件,使用qt creator编译即可,debug release均可编译.
将编译好的驱动放到Qt5.6.0\5.6\msvc2015_64\plugins\sqldrivers目录下.
使用以下代码测试:
注意将oci.dll路劲(oracle客户端bin目录)添加到系统PATH变量中#include <QApplication> #include <QSqlDatabase> int main(int argc, char *argv[]) { QApplication a(argc, argv); QSqlDatabase db = QSqlDatabase::addDatabase("QOCI"); db.setPort(1521); db.setHostName("127.0.0.1"); db.setDatabaseName("ora11g"); db.setUserName("xxxxxx"); db.setPassword("1"); if (db.open()) { qDebug() << "链接远程数据库成功了"; }else{ qDebug() << "链接远程数据库失败啊"; } return a.exec(); }