Compile Plugin Oracle OCI SQL driver Qt 5.12.2 MSVC2015 Windows Errors

[JoeBermejales]

Hi,

I'm trying to compile and install the OCI Plugin on Windows by following the official documentation at:

http://man.hubwiz.com/docset/Qt_5.docset/Contents/Resources/Documents/doc.qt.io/qt-5/sql-driver.html#how-to-build-the-oci-plugin-on-windows

cd %QTDIR%\qtbase\src\plugins\sqldrivers
qmake -- OCI_INCDIR=c:/oracle/oci/include OCI_LIBDIR=c:/oracle/oci/lib/msvc
nmake sub-oci

Executing the second line, I get:

C:\Qt\5.12.2\Src\qtbase\src\plugins\sqldrivers>qmake -- OCI_INCDIR=C:\app\jose_\product\21c\dbhomeXE\oci\include OCI_LIBDIR=C:\app\jose_\product\21c\dbhomeXE\oci\lib\msvc

Running configuration tests...
Done running configuration tests.

Configure summary:

Qt Sql Drivers:
  DB2 (IBM) .............................. no
  InterBase .............................. no
  MySql .................................. no
  OCI (Oracle) ........................... no
  ODBC ................................... no
  PostgreSQL ............................. no
  SQLite2 ................................ no
  SQLite ................................. yes
    Using system provided SQLite ......... no
  TDS (Sybase) ........................... no

Qt is now configured for building. Just run 'nmake'.
Once everything is built, you must run 'nmake install'.
Qt will be installed into 'C:\Qt\5.12.2\msvc2015_64'.

Prior to reconfiguration, make sure you remove any leftovers from
the previous build.

Then, I try to execute nmake sub-oci with the following result:

C:\Qt\5.12.2\Src\qtbase\src\plugins\sqldrivers>nmake sub-oci

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

NMAKE : fatal error U1073: don't know how to make 'sub-oci'
Stop.

If I only write "nmake", I get:

C:\Qt\5.12.2\Src\qtbase\src\plugins\sqldrivers>nmake

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

        cd sqlite\ && ( if not exist Makefile C:\Qt\5.12.2\msvc2015_64\bin\qmake.exe -o Makefile C:\Qt\5.12.2\Src\qtbase\src\plugins\sqldrivers\sqlite\sqlite.pro ) && "C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\bin\nmake.exe" -f Makefile

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

        "C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\bin\nmake.exe" -f Makefile.Release all

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

        cl -BxC:\Qt\5.12.2\msvc2015_64\bin\qmake.exe -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -O2 -Zi -MD /wd4530 /wd4577 -W3 -w34100 -w34189 -w44996 -w44456 -w44457 -w44458 -wd4577 -wd4467 -E C:\Qt\5.12.2\msvc2015_64\mkspecs\features\data\dummy.cpp 2>NUL >.moc\release\moc_predefs.h
        C:\Qt\5.12.2\msvc2015_64\bin\moc.exe -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DWIN64 -DNDEBUG -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -D_WINDLL --compiler-flavor=msvc --include C:/Qt/5.12.2/Src/qtbase/src/plugins/sqldrivers/sqlite/.moc/release/moc_predefs.h -IC:/Qt/5.12.2/msvc2015_64/mkspecs/win32-msvc -IC:/Qt/5.12.2/Src/qtbase/src/plugins/sqldrivers/sqlite -IC:/Qt/5.12.2/Src/qtbase/src/3rdparty/sqlite -IC:/Qt/5.12.2/msvc2015_64/include/QtSql/5.12.2 -IC:/Qt/5.12.2/msvc2015_64/include/QtSql/5.12.2/QtSql -IC:/Qt/5.12.2/msvc2015_64/include/QtCore/5.12.2 -IC:/Qt/5.12.2/msvc2015_64/include/QtCore/5.12.2/QtCore -IC:/Qt/5.12.2/msvc2015_64/include -IC:/Qt/5.12.2/msvc2015_64/include/QtSql -IC:/Qt/5.12.2/msvc2015_64/include/QtCore -I"C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\INCLUDE" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\ucrt" -I"C:\Program Files (x86)\Windows Kits\NETFXSDK\4.6\include\um" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\shared" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\um" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\winrt" smain.cpp -o .moc\release\smain.moc
        C:\Qt\5.12.2\msvc2015_64\bin\moc.exe -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DWIN64 -DNDEBUG -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -D_WINDLL --compiler-flavor=msvc --include C:/Qt/5.12.2/Src/qtbase/src/plugins/sqldrivers/sqlite/.moc/release/moc_predefs.h -IC:/Qt/5.12.2/msvc2015_64/mkspecs/win32-msvc -IC:/Qt/5.12.2/Src/qtbase/src/plugins/sqldrivers/sqlite -IC:/Qt/5.12.2/Src/qtbase/src/3rdparty/sqlite -IC:/Qt/5.12.2/msvc2015_64/include/QtSql/5.12.2 -IC:/Qt/5.12.2/msvc2015_64/include/QtSql/5.12.2/QtSql -IC:/Qt/5.12.2/msvc2015_64/include/QtCore/5.12.2 -IC:/Qt/5.12.2/msvc2015_64/include/QtCore/5.12.2/QtCore -IC:/Qt/5.12.2/msvc2015_64/include -IC:/Qt/5.12.2/msvc2015_64/include/QtSql -IC:/Qt/5.12.2/msvc2015_64/include/QtCore -I"C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\INCLUDE" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\ucrt" -I"C:\Program Files (x86)\Windows Kits\NETFXSDK\4.6\include\um" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\shared" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\um" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\winrt" qsql_sqlite_p.h -o .moc\release\moc_qsql_sqlite_p.cpp
        rc /NOLOGO -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DWIN64 -DNDEBUG -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -D_WINDLL -fo .obj\release\qsqlite_resource.res qsqlite_resource.rc
"rc" no se reconoce como un comando interno o externo,
programa o archivo por lotes ejecutable.
NMAKE : fatal error U1077: 'rc' : return code '0x1'
Stop.
NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\bin\nmake.exe"' : return code '0x2'
Stop.
NMAKE : fatal error U1077: 'cd' : return code '0x2'
Stop.

I have tried to follow multiple steps I found in forums and also tried to compile in Qt Creator, but I always get some kind of error like these. I also tried to reinstall the sources and to compile in another windows machine.

Did anyone get to compile/install Oracle plugin in Qt?
Is it possible to find a compiled plugin for MSVC 2015 and Qt 5.12.2?

Thank you in advance for any advice or help

[Bonnie]

@JoeBermejales I tried downloading the above package you post and built the plugin.
I'll show you the process (but I only have Qt with VS2019 installed).

First of all, run from x64 Native Tools Command Prompt:

**********************************************************************
** Visual Studio 2019 Developer Command Prompt v16.11.30
** Copyright (c) 2021 Microsoft Corporation
**********************************************************************
[vcvarsall.bat] Environment initialized for: 'x64'

//if qmake is already in your PATH, this is not needed
C:\Program Files (x86)\Microsoft Visual Studio\2019\Community>set PATH=C:\Qt\5.15.2\msvc2019_64\bin;%PATH%

C:\Program Files (x86)\Microsoft Visual Studio\2019\Community>cd C:\work\build\

C:\work\build>mkdir build-sqldrivers

C:\work\build>cd build-sqldrivers

//this is a little different from the document because I don't want to build in the source folder
C:\work\build\build-sqldrivers>qmake C:/Qt/5.15.2/Src/qtbase/src/plugins/sqldrivers/sqldrivers.pro -- OCI_INCDIR=C:/app/bonnie/product/21c/dbhomeXE/oci/include OCI_LIBDIR=C:/app/bonnie/product/21c/dbhomeXE/oci/lib/msvc
Info: creating stash file C:\work\build\build-sqldrivers\.qmake.stash

Running configuration tests...
Checking for DB2 (IBM)... no
Checking for InterBase... no
Checking for MySQL... no
Checking for OCI (Oracle)... yes
Checking for ODBC... yes
Checking for PostgreSQL... no
Checking for SQLite (version 2)... no
Checking for TDS (Sybase)... no
Done running configuration tests.

Configure summary:

Qt Sql Drivers:
  DB2 (IBM) .............................. no
  InterBase .............................. no
  MySql .................................. no
  OCI (Oracle) ........................... yes
  ODBC ................................... yes
  PostgreSQL ............................. no
  SQLite2 ................................ no
  SQLite ................................. yes
    Using system provided SQLite ......... no
  TDS (Sybase) ........................... no

Qt is now configured for building. Just run 'nmake'.
Once everything is built, you must run 'nmake install'.
Qt will be installed into 'C:\Qt\5.15.2\msvc2019_64'.

Prior to reconfiguration, make sure you remove any leftovers from
the previous build.


C:\work\build\build-sqldrivers>nmake sub-oci

After building, there are qsqloci.dll and qsqlocid.dll in ..\plugins\sqldrivers.

About the machine type conflict, I think there is a chance that you have x86 nmake in your system PATH.
Try

1. Open a normal command prompt, run: echo %PATH%
   check is there any VS path in it
2. Open x64 Native tools Command Prompt, run: echo %PATH%
   check if the first VS path should be some MSVC 2015 with x64

[Christian Ehrlicher]

As you can see in the first output make can not find the oci stuff. Look into the log files to see why. Also please follow the official documentation: https://doc.qt.io/qt-5/sql-driver.html#qoci-for-the-oracle-call-interface-oci

[JoeBermejales]

@Christian-Ehrlicher thank you for the quick reply!

This is the content of config.log

Command line: "OCI_INCDIR=C:\app\jose_\product\21c\dbhomeXE\oci\include" "OCI_LIBDIR=C:\app\jose_\product\21c\dbhomeXE\oci\lib\msvc"
Global lib dirs: [C:\\openssl\\lib C:\\Utils\\my_sql\\mysql-5.6.11-winx64\\lib C:\\Utils\\postgresql\\pgsql\\lib] ["C:\\Program Files (x86)\\Microsoft Visual Studio 14.0\\VC\\LIB\\amd64" "C:\\Program Files (x86)\\Windows Kits\\10\\lib\\10.0.22621.0\\ucrt\\x64" "C:\\Program Files (x86)\\Windows Kits\\NETFXSDK\\4.6\\lib\\um\\x64" "C:\\Program Files (x86)\\Windows Kits\\10\\lib\\10.0.22621.0\\um\\x64"]
Global inc dirs: [C:\\openssl\\include C:\\Utils\\my_sql\\mysql-5.6.11-winx64\\include C:\\Utils\\postgresql\\pgsql\\include] ["C:\\Program Files (x86)\\Microsoft Visual Studio 14.0\\VC\\INCLUDE" "C:\\Program Files (x86)\\Windows Kits\\10\\include\\10.0.22621.0\\ucrt" "C:\\Program Files (x86)\\Windows Kits\\NETFXSDK\\4.6\\include\\um" "C:\\Program Files (x86)\\Windows Kits\\10\\include\\10.0.22621.0\\shared" "C:\\Program Files (x86)\\Windows Kits\\10\\include\\10.0.22621.0\\um" "C:\\Program Files (x86)\\Windows Kits\\10\\include\\10.0.22621.0\\winrt"]
loaded result for library config.sqldrivers.libraries.db2
Trying source 0 (type inline) of library db2 ...
None of [db2cli.lib] found in [] and global paths.
  => source produced no result.
Trying source 1 (type inline) of library db2 ...
  => source failed condition '!config.win32'.
test config.sqldrivers.libraries.db2 FAILED
loaded result for library config.sqldrivers.libraries.ibase
Trying source 0 (type inline) of library ibase ...
None of [gds32_ms.lib] found in [] and global paths.
  => source produced no result.
Trying source 1 (type inline) of library ibase ...
  => source failed condition '!config.win32'.
test config.sqldrivers.libraries.ibase FAILED
loaded result for library config.sqldrivers.libraries.mysql
Trying source 0 (type mysqlConfig) of library mysql ...
mysql_config not found.
  => source produced no result.
Trying source 1 (type mysqlConfig) of library mysql ...
mysql_config not found.
  => source produced no result.
Trying source 2 (type mysqlConfig) of library mysql ...
mysql_config not found.
  => source produced no result.
Trying source 3 (type mysqlConfig) of library mysql ...
mysql_config not found.
  => source produced no result.
Trying source 4 (type inline) of library mysql ...
  => source failed condition '!config.win32'.
Trying source 5 (type inline) of library mysql ...
None of [libmysql.lib] found in [] and global paths.
  => source produced no result.
Trying source 6 (type inline) of library mysql ...
  => source failed condition '!config.win32'.
test config.sqldrivers.libraries.mysql FAILED
loaded result for library config.sqldrivers.libraries.oci
Trying source 0 (type inline) of library oci ...
+ cd /d C:\Qt\5.12.2\Src\qtbase\src\plugins\sqldrivers\config.tests\oci && C:\Qt\5.12.2\msvc2015_64\bin\qmake.exe "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" "QMAKE_LIBDIR += C:\\openssl\\lib C:\\Utils\\my_sql\\mysql-5.6.11-winx64\\lib C:\\Utils\\postgresql\\pgsql\\lib" "INCLUDEPATH += C:\\openssl\\include C:\\Utils\\my_sql\\mysql-5.6.11-winx64\\include C:\\Utils\\postgresql\\pgsql\\include" "QMAKE_USE += oci" "QMAKE_LIBS_OCI = C:\\app\\jose_\\product\\21c\\dbhomeXE\\oci\\lib\\msvc/oci.lib" "QMAKE_INCDIR_OCI = C:\\app\\jose_\\product\\21c\\dbhomeXE\\oci\\include" C:/Qt/5.12.2/Src/qtbase/src/plugins/sqldrivers/config.tests/oci
> Info: creating stash file C:\Qt\5.12.2\Src\qtbase\src\plugins\sqldrivers\config.tests\.qmake.stash
+ cd /d C:\Qt\5.12.2\Src\qtbase\src\plugins\sqldrivers\config.tests\oci && set MAKEFLAGS=& nmake
> Microsoft (R) Program Maintenance Utility Version 14.00.23026.0
> Copyright (C) Microsoft Corporation.  All rights reserved.
> 	cl -c -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -O2 -MD -W0 -EHsc -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DWIN64 -DNDEBUG -I. -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.6.11-winx64\include -IC:\Utils\postgresql\pgsql\include -IC:\app\jose_\product\21c\dbhomeXE\oci\include -IC:\Qt\5.12.2\msvc2015_64\mkspecs\win32-msvc -Fo @C:\Users\jose_\AppData\Local\Temp\nm577D.tmp
> main.cpp
> C:\app\jose_\product\21c\dbhomeXE\oci\include\oratypes.h(18): fatal error C1083: Cannot open include file: 'stddef.h': No such file or directory
> NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\bin\cl.EXE"' : return code '0x2'
> Stop.
 => source failed verification.
Trying source 1 (type inline) of library oci ...
  => source failed condition '!config.win32'.
test config.sqldrivers.libraries.oci FAILED
loaded result for library config.sqldrivers.libraries.odbc
Trying source 0 (type inline) of library odbc ...
+ cd /d C:\Qt\5.12.2\Src\qtbase\src\plugins\sqldrivers\config.tests\odbc && C:\Qt\5.12.2\msvc2015_64\bin\qmake.exe "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" "QMAKE_LIBDIR += C:\\openssl\\lib C:\\Utils\\my_sql\\mysql-5.6.11-winx64\\lib C:\\Utils\\postgresql\\pgsql\\lib" "INCLUDEPATH += C:\\openssl\\include C:\\Utils\\my_sql\\mysql-5.6.11-winx64\\include C:\\Utils\\postgresql\\pgsql\\include" "QMAKE_USE += odbc" "QMAKE_LIBS_ODBC = \"C:\\Program Files ^(x86^)\\Windows Kits\\10\\lib\\10.0.22621.0\\um\\x64/odbc32.lib\"" C:/Qt/5.12.2/Src/qtbase/src/plugins/sqldrivers/config.tests/odbc
+ cd /d C:\Qt\5.12.2\Src\qtbase\src\plugins\sqldrivers\config.tests\odbc && set MAKEFLAGS=& nmake
> Microsoft (R) Program Maintenance Utility Version 14.00.23026.0
> Copyright (C) Microsoft Corporation.  All rights reserved.
> 	cl -c -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -O2 -MD -W0 -EHsc -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DWIN64 -DNDEBUG -I. -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.6.11-winx64\include -IC:\Utils\postgresql\pgsql\include -IC:\Qt\5.12.2\msvc2015_64\mkspecs\win32-msvc -Fo @C:\Users\jose_\AppData\Local\Temp\nm5809.tmp
> main.cpp
> .\main.cpp(3): fatal error C1083: Cannot open include file: 'windows.h': No such file or directory
> NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\bin\cl.EXE"' : return code '0x2'
> Stop.
 => source failed verification.
Trying source 1 (type inline) of library odbc ...
  => source failed condition 'config.darwin'.
Trying source 2 (type inline) of library odbc ...
  => source failed condition '!config.win32 && !config.darwin'.
test config.sqldrivers.libraries.odbc FAILED
loaded result for library config.sqldrivers.libraries.psql
Trying source 0 (type pkgConfig) of library psql ...
pkg-config use disabled globally.
  => source produced no result.
Trying source 1 (type psqlConfig) of library psql ...
pg_config not found.
  => source produced no result.
Trying source 2 (type psqlEnv) of library psql ...
None of [libpq.lib] found in [] and global paths.
  => source produced no result.
Trying source 3 (type psqlEnv) of library psql ...
  => source failed condition '!config.win32'.
test config.sqldrivers.libraries.psql FAILED
loaded result for library config.sqldrivers.libraries.sqlite2
Trying source 0 (type inline) of library sqlite2 ...
None of [sqlite.lib] found in [] and global paths.
  => source produced no result.
test config.sqldrivers.libraries.sqlite2 FAILED
loaded result for library config.sqldrivers.libraries.tds
Trying source 0 (type sybaseEnv) of library tds ...
None of [NTWDBLIB.lib] found in [] and global paths.
  => source produced no result.
Trying source 1 (type sybaseEnv) of library tds ...
  => source failed condition '!config.win32'.
test config.sqldrivers.libraries.tds FAILED

I seems the main error is:

> C:\app\jose_\product\21c\dbhomeXE\oci\include\oratypes.h(18): fatal error C1083: Cannot open include file: 'stddef.h': No such file or directory

How can I solve it? where stddef.h come from?

Thanks!

[Christian Ehrlicher]

stddef.h is normally shipped with the windows sdk so it should be on your pc. Make sure you properly set up the compiler environment by opening the correct Native Tools Command Prompt or calling the correct vsvars.bat.

[JoeBermejales]

@Christian-Ehrlicher tried again in another computer, with the qt console cmd (Qt 5.12.2 (MSVC 2015 64bit) and again the same error.

Command line: "OCI_INCDIR=C:\app\jose.inesta\product\21c\dbhomeXE\oci\include" "OCI_LIBDIR=C:\app\jose.inesta\product\21c\dbhomeXE\oci\lib\msvc"
Global lib dirs: [C:\\openssl\\lib C:\\Utils\\my_sql\\mysql-5.6.11-winx64\\lib C:\\Utils\\postgresql\\pgsql\\lib] []
Global inc dirs: [C:\\openssl\\include C:\\Utils\\my_sql\\mysql-5.6.11-winx64\\include C:\\Utils\\postgresql\\pgsql\\include] []
looking for library db2
Trying source 0 (type inline) of library db2 ...
None of [db2cli.lib] found in [] and global paths.
  => source produced no result.
Trying source 1 (type inline) of library db2 ...
  => source failed condition '!config.win32'.
test config.sqldrivers.libraries.db2 FAILED
looking for library ibase
Trying source 0 (type inline) of library ibase ...
None of [gds32_ms.lib] found in [] and global paths.
  => source produced no result.
Trying source 1 (type inline) of library ibase ...
  => source failed condition '!config.win32'.
test config.sqldrivers.libraries.ibase FAILED
looking for library mysql
Trying source 0 (type mysqlConfig) of library mysql ...
mysql_config not found.
  => source produced no result.
Trying source 1 (type mysqlConfig) of library mysql ...
mysql_config not found.
  => source produced no result.
Trying source 2 (type mysqlConfig) of library mysql ...
mysql_config not found.
  => source produced no result.
Trying source 3 (type mysqlConfig) of library mysql ...
mysql_config not found.
  => source produced no result.
Trying source 4 (type inline) of library mysql ...
  => source failed condition '!config.win32'.
Trying source 5 (type inline) of library mysql ...
None of [libmysql.lib] found in [] and global paths.
  => source produced no result.
Trying source 6 (type inline) of library mysql ...
  => source failed condition '!config.win32'.
test config.sqldrivers.libraries.mysql FAILED
looking for library oci
Trying source 0 (type inline) of library oci ...
+ cd /d C:\Qt\5.12.2\Src\qtbase\src\plugins\sqldrivers\config.tests\oci && C:\Qt\5.12.2\msvc2015_64\bin\qmake.exe "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" "QMAKE_LIBDIR += C:\\openssl\\lib C:\\Utils\\my_sql\\mysql-5.6.11-winx64\\lib C:\\Utils\\postgresql\\pgsql\\lib" "INCLUDEPATH += C:\\openssl\\include C:\\Utils\\my_sql\\mysql-5.6.11-winx64\\include C:\\Utils\\postgresql\\pgsql\\include" "QMAKE_USE += oci" "QMAKE_LIBS_OCI = C:\\app\\jose.inesta\\product\\21c\\dbhomeXE\\oci\\lib\\msvc/oci.lib" "QMAKE_INCDIR_OCI = C:\\app\\jose.inesta\\product\\21c\\dbhomeXE\\oci\\include" C:/Qt/5.12.2/Src/qtbase/src/plugins/sqldrivers/config.tests/oci
+ cd /d C:\Qt\5.12.2\Src\qtbase\src\plugins\sqldrivers\config.tests\oci && set MAKEFLAGS=& nmake clean && set MAKEFLAGS=& nmake
> Utilidad de mantenimiento de programas de Microsoft (R) versi�n 14.29.30136.0
> (C) Microsoft Corporation. Todos los derechos reservados.
> 	del main.obj
> No se pudo encontrar C:\Qt\5.12.2\Src\qtbase\src\plugins\sqldrivers\config.tests\oci\main.obj
> 	del oci.exp
> No se pudo encontrar C:\Qt\5.12.2\Src\qtbase\src\plugins\sqldrivers\config.tests\oci\oci.exp
> Utilidad de mantenimiento de programas de Microsoft (R) versi�n 14.29.30136.0
> (C) Microsoft Corporation. Todos los derechos reservados.
> 	cl -c -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -Zc:referenceBinding -Zc:__cplusplus -O2 -MD -W0 -EHsc -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DWIN64 -DNDEBUG -I. -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.6.11-winx64\include -IC:\Utils\postgresql\pgsql\include -IC:\app\jose.inesta\product\21c\dbhomeXE\oci\include -IC:\Qt\5.12.2\msvc2015_64\mkspecs\win32-msvc -Fo @C:\Users\JOSE~1.INE\AppData\Local\Temp\nm8B9E.tmp
> main.cpp
> C:\app\jose.inesta\product\21c\dbhomeXE\oci\include\oratypes.h(18): fatal error C1083: No se puede abrir el archivo incluir: 'stddef.h': No such file or directory
> NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Tools\MSVC\14.29.30133\bin\Hostx64\x64\cl.EXE"' : c�digo devuelto '0x2'
> Stop.
 => source failed verification.
Trying source 1 (type inline) of library oci ...
  => source failed condition '!config.win32'.
test config.sqldrivers.libraries.oci FAILED
looking for library odbc
Trying source 0 (type inline) of library odbc ...
None of [odbc32.lib] found in [] and global paths.
  => source produced no result.
Trying source 1 (type inline) of library odbc ...
  => source failed condition 'config.darwin'.
Trying source 2 (type inline) of library odbc ...
  => source failed condition '!config.win32 && !config.darwin'.
test config.sqldrivers.libraries.odbc FAILED
looking for library psql
Trying source 0 (type pkgConfig) of library psql ...
pkg-config use disabled globally.
  => source produced no result.
Trying source 1 (type psqlConfig) of library psql ...
pg_config not found.
  => source produced no result.
Trying source 2 (type psqlEnv) of library psql ...
None of [libpq.lib] found in [] and global paths.
None of [ws2_32.lib] found in [] and global paths.
None of [advapi32.lib] found in [] and global paths.
  => source produced no result.
Trying source 3 (type psqlEnv) of library psql ...
  => source failed condition '!config.win32'.
test config.sqldrivers.libraries.psql FAILED
looking for library sqlite2
Trying source 0 (type inline) of library sqlite2 ...
None of [sqlite.lib] found in [] and global paths.
  => source produced no result.
test config.sqldrivers.libraries.sqlite2 FAILED
looking for library tds
Trying source 0 (type sybaseEnv) of library tds ...
None of [NTWDBLIB.lib] found in [] and global paths.
  => source produced no result.
Trying source 1 (type sybaseEnv) of library tds ...
  => source failed condition '!config.win32'.
test config.sqldrivers.libraries.tds FAILED

Could it be related to Oracle version? I just downloaded the OracleXE213_Win64 version, and tested ok with Sql Developer 23.1.0 and also with a simple python script.

Do you know it is possible to download the compiled plugin from any sources? I searched but no chance.

Thanks.

[Christian Ehrlicher]

stdedef.h is on your computer and has to be found by the compiler so what should some external lib has to do with this? Properly set up your compiler env where your can compile a main.cpp which only includes stddef.h and then the plugin will be compiled successful. Nothing Qt or Oracle can do against it.

[JoeBermejales]

@Christian-Ehrlicher yes, I did a simple compilation and get errors:

My main.cpp file:

#include <stddef.h>

int main() {
    return 0;
}

If I try to compile it, I get the error "no include path set"

C:\Users\jose_>cl main.cpp
Microsoft (R) C/C++ Optimizing Compiler Version 19.00.23026 for x86
Copyright (C) Microsoft Corporation.  All rights reserved.

main.cpp
main.cpp(1): fatal error C1034: stddef.h: no include path set

Then, I execute vsvars32.bat to configure vars:

C:\Users\jose_>vsvars32
C:\Users\jose_>cl main.cpp
Microsoft (R) C/C++ Optimizing Compiler Version 19.00.23026 for x86
Copyright (C) Microsoft Corporation.  All rights reserved.

main.cpp
Microsoft (R) Incremental Linker Version 14.00.23026.0
Copyright (C) Microsoft Corporation.  All rights reserved.

/out:main.exe
main.obj
LINK : fatal error LNK1104: cannot open file 'LIBCMT.lib'

I now have the error LINK : fatal error LNK1104: cannot open file 'LIBCMT.lib'

Will continue figuring out this way.

[Christian Ehrlicher]

@JoeBermejales said in Compile Plugin Oracle OCI SQL driver Qt 5.12.2 MSVC2015 Windows Errors:

Will continue figuring out this way

Why? Compilation succeeds as I demanded. Also I told you to properly call vsvars what you did and it solved the error as expected.

[JoeBermejales]

@JoeBermejales yes, but then I get the LNK1104 error and coudn't create the main.exe.

I installed Visual Studio 2015 Community Edition and compiled some examples in cpp.

Then I return to the Qt 5.12.2 MSVC2015 64 bit console and was able to run successfully the first step (first I had to delete the files from previous compilation) :

C:\Qt\5.12.2\Src\qtbase\src\plugins\sqldrivers>qmake -- OCI_INCDIR=C:\app\jose_\product\21c\dbhomeXE\oci\include OCI_LIBDIR=C:\app\jose_\product\21c\dbhomeXE\oci\lib\msvc

Running configuration tests...
Done running configuration tests.

Configure summary:

Qt Sql Drivers:
  DB2 (IBM) .............................. no
  InterBase .............................. no
  MySql .................................. no
  OCI (Oracle) ........................... yes
  ODBC ................................... no
  PostgreSQL ............................. no
  SQLite2 ................................ no
  SQLite ................................. yes
    Using system provided SQLite ......... no
  TDS (Sybase) ........................... no

Qt is now configured for building. Just run 'nmake'.
Once everything is built, you must run 'nmake install'.
Qt will be installed into 'C:\Qt\5.12.2\msvc2015_64'.

Prior to reconfiguration, make sure you remove any leftovers from
the previous build.

Note that OCI (Oracle) is "yes" now.

Then, I run "nmake" but I get the following error:

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

        cd oci\ && ( if not exist Makefile C:\Qt\5.12.2\msvc2015_64\bin\qmake.exe -o Makefile C:\Qt\5.12.2\Src\qtbase\src\plugins\sqldrivers\oci\oci.pro ) && "C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\nmake.exe" -f Makefile

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

        "C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\nmake.exe" -f Makefile.Release all

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

        link /NOLOGO /DYNAMICBASE /NXCOMPAT /DEBUG /OPT:REF /INCREMENTAL:NO /DLL /SUBSYSTEM:WINDOWS /VERSION:5.12 /OUT:..\plugins\sqldrivers\qsqloci.dll @C:\Users\jose_\AppData\Local\Temp\nm9816.tmp
Qt5Sql.lib(Qt5Sql.dll) : fatal error LNK1112: module machine type 'x64' conflicts with target machine type 'X86'
NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\link.EXE"' : return code '0x458'
Stop.
NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\nmake.exe"' : return code '0x2'
Stop.
NMAKE : fatal error U1077: 'cd' : return code '0x2'
Stop.

It seems that the environment is configured (via vsvar32.bat) for x86 instead of x64.

Then I tried to use the command "vcvarsall" as indicated in this post

C:\Qt\5.12.2\Src\qtbase\src\plugins\sqldrivers>vcvarsall.exe amd64

But the tool is not in the system, I searched in Visual Studio files and qt and nothing.

Any idea?

[Christian Ehrlicher]

The bat file is there. And as I said there is also a start menu entry which sets up the environment...

[jsulm]

@JoeBermejales Could also be that the OCI lib is x86 and not x86_64

[JoeBermejales]

I tried with native tools console x86 and x64, same error

[jsulm]

@JoeBermejales Is OCI lib x86 or x86_64?

[JoeBermejales]

@jsulm My target app/compiler is 64 bits, so for install the Qt Plugin I guess it should be x86_64.

[jsulm]

@JoeBermejales I'm talking about the OCI client library (OCI_LIBDIR=C:\app\jose_\product\21c\dbhomeXE\oci\lib\msvc)

[JoeBermejales]

@JoeBermejales This is the content of the folder C:\app\jose_\product\21c\dbhomeXE\oci\lib\msvc:

I downloaded the 64 bits edition of Oracle XE from https://www.oracle.com/es/database/technologies/xe-downloads.html:

[Bonnie]

@JoeBermejales Why are you calling vsvar32 in VS native tools console?
Just running x64 native tools should be enough.
BTW from searching in my PC, I found that stddef.h used by MSVC is from Windows Kits (Windows SDK), do you have that installed?

[JoeBermejales]

@Bonnie I already tried with the others consoles:

• I downloaded a 64 bits Oracle XE client: instantclient-sdk-windows.x64-21.11.0.0.0dbru to discard a platform mistmatch.

• I opened the VS2015 x64 Native tools Command Prompt and follow the steps:

Summary:

1. cd C:\Qt\5.12.2\Src\qtbase\src\plugins\sqldrivers
2. qmake -- OCI_INCDIR=C:\Users\jose_\Downloads\instantclient-sdk-windows.x64-21.11.0.0.0dbru.zip\instantclient_21_11\sdk\include OCI_LIBDIR=C:\Users\jose_\Downloads\instantclient-sdk-windows.x64-21.11.0.0.0dbru.zip\instantclient_21_11\sdk\lib\msvc
3. nmake
4. Get the error: Qt5Sql.lib(Qt5Sql.dll) : fatal error LNK1112: module machine type 'x64' conflicts with target machine type 'X86'

Full log:

C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC>cd C:\Qt\5.12.2\Src\qtbase\src\plugins\sqldrivers

C:\Qt\5.12.2\Src\qtbase\src\plugins\sqldrivers>qmake -- OCI_INCDIR=C:\Users\jose_\Downloads\instantclient-sdk-windows.x64-21.11.0.0.0dbru.zip\instantclient_21_11\sdk\include OCI_LIBDIR=C:\Users\jose_\Downloads\instantclient-sdk-windows.x64-21.11.0.0.0dbru.zip\instantclient_21_11\sdk\lib\msvc

Running configuration tests...
Checking for DB2 (IBM)... no
Checking for InterBase... no
Checking for MySQL... no
Checking for OCI (Oracle)... no
Checking for ODBC... yes
Checking for PostgreSQL... no
Checking for SQLite (version 2)... no
Checking for TDS (Sybase)... no
Done running configuration tests.

Configure summary:

Qt Sql Drivers:
  DB2 (IBM) .............................. no
  InterBase .............................. no
  MySql .................................. no
  OCI (Oracle) ........................... no
  ODBC ................................... yes
  PostgreSQL ............................. no
  SQLite2 ................................ no
  SQLite ................................. yes
    Using system provided SQLite ......... no
  TDS (Sybase) ........................... no

Qt is now configured for building. Just run 'nmake'.
Once everything is built, you must run 'nmake install'.
Qt will be installed into 'C:\Qt\5.12.2\msvc2015_64'.

Prior to reconfiguration, make sure you remove any leftovers from
the previous build.


C:\Qt\5.12.2\Src\qtbase\src\plugins\sqldrivers>nmake

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

        cd odbc\ && ( if not exist Makefile C:\Qt\5.12.2\msvc2015_64\bin\qmake.exe -o Makefile C:\Qt\5.12.2\Src\qtbase\src\plugins\sqldrivers\odbc\odbc.pro ) && "C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\amd64\nmake.exe" -f Makefile

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

        "C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\amd64\nmake.exe" -f Makefile.Release all

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

        cl -BxC:\Qt\5.12.2\msvc2015_64\bin\qmake.exe -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -O2 -Zi -MD /wd4530 /wd4577 -W3 -w34100 -w34189 -w44996 -w44456 -w44457 -w44458 -wd4577 -wd4467 -E C:\Qt\5.12.2\msvc2015_64\mkspecs\features\data\dummy.cpp 2>NUL >.moc\release\moc_predefs.h
        C:\Qt\5.12.2\msvc2015_64\bin\moc.exe -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DWIN64 -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -DNDEBUG -D_WINDLL --compiler-flavor=msvc --include C:/Qt/5.12.2/Src/qtbase/src/plugins/sqldrivers/odbc/.moc/release/moc_predefs.h -IC:/Qt/5.12.2/msvc2015_64/mkspecs/win32-msvc -IC:/Qt/5.12.2/Src/qtbase/src/plugins/sqldrivers/odbc -IC:/Qt/5.12.2/msvc2015_64/include/QtSql/5.12.2 -IC:/Qt/5.12.2/msvc2015_64/include/QtSql/5.12.2/QtSql -IC:/Qt/5.12.2/msvc2015_64/include/QtCore/5.12.2 -IC:/Qt/5.12.2/msvc2015_64/include/QtCore/5.12.2/QtCore -IC:/Qt/5.12.2/msvc2015_64/include -IC:/Qt/5.12.2/msvc2015_64/include/QtSql -IC:/Qt/5.12.2/msvc2015_64/include/QtCore -I"C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\INCLUDE" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\ucrt" -I"C:\Program Files (x86)\Windows Kits\NETFXSDK\4.6\include\um" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\shared" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\um" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\winrt" main.cpp -o .moc\release\main.moc
        C:\Qt\5.12.2\msvc2015_64\bin\moc.exe -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DWIN64 -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -DNDEBUG -D_WINDLL --compiler-flavor=msvc --include C:/Qt/5.12.2/Src/qtbase/src/plugins/sqldrivers/odbc/.moc/release/moc_predefs.h -IC:/Qt/5.12.2/msvc2015_64/mkspecs/win32-msvc -IC:/Qt/5.12.2/Src/qtbase/src/plugins/sqldrivers/odbc -IC:/Qt/5.12.2/msvc2015_64/include/QtSql/5.12.2 -IC:/Qt/5.12.2/msvc2015_64/include/QtSql/5.12.2/QtSql -IC:/Qt/5.12.2/msvc2015_64/include/QtCore/5.12.2 -IC:/Qt/5.12.2/msvc2015_64/include/QtCore/5.12.2/QtCore -IC:/Qt/5.12.2/msvc2015_64/include -IC:/Qt/5.12.2/msvc2015_64/include/QtSql -IC:/Qt/5.12.2/msvc2015_64/include/QtCore -I"C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\INCLUDE" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\ucrt" -I"C:\Program Files (x86)\Windows Kits\NETFXSDK\4.6\include\um" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\shared" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\um" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\winrt" qsql_odbc_p.h -o .moc\release\moc_qsql_odbc_p.cpp
        rc /NOLOGO -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DWIN64 -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -DNDEBUG -D_WINDLL -fo .obj\release\qsqlodbc_resource.res qsqlodbc_resource.rc
        cl -c -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -O2 -Zi -MD /wd4530 /wd4577 -W3 -w34100 -w34189 -w44996 -w44456 -w44457 -w44458 -wd4577 -wd4467 /Fd.obj\release\qsqlodbc.vc.pdb -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DWIN64 -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -DNDEBUG -D_WINDLL -I. -IC:\Qt\5.12.2\msvc2015_64\include\QtSql\5.12.2 -IC:\Qt\5.12.2\msvc2015_64\include\QtSql\5.12.2\QtSql -IC:\Qt\5.12.2\msvc2015_64\include\QtCore\5.12.2 -IC:\Qt\5.12.2\msvc2015_64\include\QtCore\5.12.2\QtCore -IC:\Qt\5.12.2\msvc2015_64\include -IC:\Qt\5.12.2\msvc2015_64\include\QtSql -IC:\Qt\5.12.2\msvc2015_64\include\QtCore -I.moc\release -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.6.11-winx64\include -IC:\Utils\postgresql\pgsql\include -IC:\Qt\5.12.2\msvc2015_64\mkspecs\win32-msvc -Fo.obj\release\ @C:\Users\jose_\AppData\Local\Temp\nm402F.tmp
qsql_odbc.cpp
main.cpp
Generating Code...
        cl -c -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -O2 -Zi -MD /wd4530 /wd4577 -W3 -w34100 -w34189 -w44996 -w44456 -w44457 -w44458 -wd4577 -wd4467 /Fd.obj\release\qsqlodbc.vc.pdb -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DWIN64 -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -DNDEBUG -D_WINDLL -I. -IC:\Qt\5.12.2\msvc2015_64\include\QtSql\5.12.2 -IC:\Qt\5.12.2\msvc2015_64\include\QtSql\5.12.2\QtSql -IC:\Qt\5.12.2\msvc2015_64\include\QtCore\5.12.2 -IC:\Qt\5.12.2\msvc2015_64\include\QtCore\5.12.2\QtCore -IC:\Qt\5.12.2\msvc2015_64\include -IC:\Qt\5.12.2\msvc2015_64\include\QtSql -IC:\Qt\5.12.2\msvc2015_64\include\QtCore -I.moc\release -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.6.11-winx64\include -IC:\Utils\postgresql\pgsql\include -IC:\Qt\5.12.2\msvc2015_64\mkspecs\win32-msvc -Fo.obj\release\ @C:\Users\jose_\AppData\Local\Temp\nm4958.tmp
moc_qsql_odbc_p.cpp
        link /NOLOGO /DYNAMICBASE /NXCOMPAT /DEBUG /OPT:REF /INCREMENTAL:NO /DLL /SUBSYSTEM:WINDOWS /VERSION:5.12 /OUT:..\plugins\sqldrivers\qsqlodbc.dll @C:\Users\jose_\AppData\Local\Temp\nm4CF3.tmp
   Creating library ..\plugins\sqldrivers\qsqlodbc.lib and object ..\plugins\sqldrivers\qsqlodbc.exp
        "C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\amd64\nmake.exe" -f Makefile.Debug all

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

        cl -BxC:\Qt\5.12.2\msvc2015_64\bin\qmake.exe -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -Zi -MDd /wd4530 /wd4577 -W3 -w34100 -w34189 -w44996 -w44456 -w44457 -w44458 -wd4577 -wd4467 -E C:\Qt\5.12.2\msvc2015_64\mkspecs\features\data\dummy.cpp 2>NUL >.moc\debug\moc_predefs.h
        C:\Qt\5.12.2\msvc2015_64\bin\moc.exe -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DWIN64 -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -D_WINDLL --compiler-flavor=msvc --include C:/Qt/5.12.2/Src/qtbase/src/plugins/sqldrivers/odbc/.moc/debug/moc_predefs.h -IC:/Qt/5.12.2/msvc2015_64/mkspecs/win32-msvc -IC:/Qt/5.12.2/Src/qtbase/src/plugins/sqldrivers/odbc -IC:/Qt/5.12.2/msvc2015_64/include/QtSql/5.12.2 -IC:/Qt/5.12.2/msvc2015_64/include/QtSql/5.12.2/QtSql -IC:/Qt/5.12.2/msvc2015_64/include/QtCore/5.12.2 -IC:/Qt/5.12.2/msvc2015_64/include/QtCore/5.12.2/QtCore -IC:/Qt/5.12.2/msvc2015_64/include -IC:/Qt/5.12.2/msvc2015_64/include/QtSql -IC:/Qt/5.12.2/msvc2015_64/include/QtCore -I"C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\INCLUDE" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\ucrt" -I"C:\Program Files (x86)\Windows Kits\NETFXSDK\4.6\include\um" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\shared" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\um" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\winrt" main.cpp -o .moc\debug\main.moc
        C:\Qt\5.12.2\msvc2015_64\bin\moc.exe -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DWIN64 -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -D_WINDLL --compiler-flavor=msvc --include C:/Qt/5.12.2/Src/qtbase/src/plugins/sqldrivers/odbc/.moc/debug/moc_predefs.h -IC:/Qt/5.12.2/msvc2015_64/mkspecs/win32-msvc -IC:/Qt/5.12.2/Src/qtbase/src/plugins/sqldrivers/odbc -IC:/Qt/5.12.2/msvc2015_64/include/QtSql/5.12.2 -IC:/Qt/5.12.2/msvc2015_64/include/QtSql/5.12.2/QtSql -IC:/Qt/5.12.2/msvc2015_64/include/QtCore/5.12.2 -IC:/Qt/5.12.2/msvc2015_64/include/QtCore/5.12.2/QtCore -IC:/Qt/5.12.2/msvc2015_64/include -IC:/Qt/5.12.2/msvc2015_64/include/QtSql -IC:/Qt/5.12.2/msvc2015_64/include/QtCore -I"C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\INCLUDE" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\ucrt" -I"C:\Program Files (x86)\Windows Kits\NETFXSDK\4.6\include\um" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\shared" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\um" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\winrt" qsql_odbc_p.h -o .moc\debug\moc_qsql_odbc_p.cpp
        rc /NOLOGO -D_DEBUG -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DWIN64 -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -D_WINDLL -fo .obj\debug\qsqlodbcd_resource.res qsqlodbcd_resource.rc
        cl -c -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -Zi -MDd /wd4530 /wd4577 -W3 -w34100 -w34189 -w44996 -w44456 -w44457 -w44458 -wd4577 -wd4467 /Fd.obj\debug\qsqlodbcd.vc.pdb -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DWIN64 -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -D_WINDLL -I. -IC:\Qt\5.12.2\msvc2015_64\include\QtSql\5.12.2 -IC:\Qt\5.12.2\msvc2015_64\include\QtSql\5.12.2\QtSql -IC:\Qt\5.12.2\msvc2015_64\include\QtCore\5.12.2 -IC:\Qt\5.12.2\msvc2015_64\include\QtCore\5.12.2\QtCore -IC:\Qt\5.12.2\msvc2015_64\include -IC:\Qt\5.12.2\msvc2015_64\include\QtSql -IC:\Qt\5.12.2\msvc2015_64\include\QtCore -I.moc\debug -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.6.11-winx64\include -IC:\Utils\postgresql\pgsql\include -IC:\Qt\5.12.2\msvc2015_64\mkspecs\win32-msvc -Fo.obj\debug\ @C:\Users\jose_\AppData\Local\Temp\nm5389.tmp
qsql_odbc.cpp
main.cpp
Generating Code...
        cl -c -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -Zi -MDd /wd4530 /wd4577 -W3 -w34100 -w34189 -w44996 -w44456 -w44457 -w44458 -wd4577 -wd4467 /Fd.obj\debug\qsqlodbcd.vc.pdb -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DWIN64 -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -D_WINDLL -I. -IC:\Qt\5.12.2\msvc2015_64\include\QtSql\5.12.2 -IC:\Qt\5.12.2\msvc2015_64\include\QtSql\5.12.2\QtSql -IC:\Qt\5.12.2\msvc2015_64\include\QtCore\5.12.2 -IC:\Qt\5.12.2\msvc2015_64\include\QtCore\5.12.2\QtCore -IC:\Qt\5.12.2\msvc2015_64\include -IC:\Qt\5.12.2\msvc2015_64\include\QtSql -IC:\Qt\5.12.2\msvc2015_64\include\QtCore -I.moc\debug -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.6.11-winx64\include -IC:\Utils\postgresql\pgsql\include -IC:\Qt\5.12.2\msvc2015_64\mkspecs\win32-msvc -Fo.obj\debug\ @C:\Users\jose_\AppData\Local\Temp\nm5B2B.tmp
moc_qsql_odbc_p.cpp
        link /NOLOGO /DYNAMICBASE /NXCOMPAT /DEBUG /DLL /SUBSYSTEM:WINDOWS /VERSION:5.12 /OUT:..\plugins\sqldrivers\qsqlodbcd.dll @C:\Users\jose_\AppData\Local\Temp\nm5EE5.tmp
        cd sqlite\ && ( if not exist Makefile C:\Qt\5.12.2\msvc2015_64\bin\qmake.exe -o Makefile C:\Qt\5.12.2\Src\qtbase\src\plugins\sqldrivers\sqlite\sqlite.pro ) && "C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\amd64\nmake.exe" -f Makefile

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

        "C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\amd64\nmake.exe" -f Makefile.Release all

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

        link /NOLOGO /DYNAMICBASE /NXCOMPAT /DEBUG /OPT:REF /INCREMENTAL:NO /DLL /SUBSYSTEM:WINDOWS /VERSION:5.12 /OUT:..\plugins\sqldrivers\qsqlite.dll @C:\Users\jose_\AppData\Local\Temp\nm605A.tmp
Qt5Sql.lib(Qt5Sql.dll) : fatal error LNK1112: module machine type 'x64' conflicts with target machine type 'X86'
NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\amd64\link.EXE"' : return code '0x458'
Stop.
NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\amd64\nmake.exe"' : return code '0x2'
Stop.
NMAKE : fatal error U1077: 'cd' : return code '0x2'
Stop.

C:\Qt\5.12.2\Src\qtbase\src\plugins\sqldrivers>

Why??

[Bonnie]

@JoeBermejales I tried downloading the above package you post and built the plugin.
I'll show you the process (but I only have Qt with VS2019 installed).

First of all, run from x64 Native Tools Command Prompt:

**********************************************************************
** Visual Studio 2019 Developer Command Prompt v16.11.30
** Copyright (c) 2021 Microsoft Corporation
**********************************************************************
[vcvarsall.bat] Environment initialized for: 'x64'

//if qmake is already in your PATH, this is not needed
C:\Program Files (x86)\Microsoft Visual Studio\2019\Community>set PATH=C:\Qt\5.15.2\msvc2019_64\bin;%PATH%

C:\Program Files (x86)\Microsoft Visual Studio\2019\Community>cd C:\work\build\

C:\work\build>mkdir build-sqldrivers

C:\work\build>cd build-sqldrivers

//this is a little different from the document because I don't want to build in the source folder
C:\work\build\build-sqldrivers>qmake C:/Qt/5.15.2/Src/qtbase/src/plugins/sqldrivers/sqldrivers.pro -- OCI_INCDIR=C:/app/bonnie/product/21c/dbhomeXE/oci/include OCI_LIBDIR=C:/app/bonnie/product/21c/dbhomeXE/oci/lib/msvc
Info: creating stash file C:\work\build\build-sqldrivers\.qmake.stash

Running configuration tests...
Checking for DB2 (IBM)... no
Checking for InterBase... no
Checking for MySQL... no
Checking for OCI (Oracle)... yes
Checking for ODBC... yes
Checking for PostgreSQL... no
Checking for SQLite (version 2)... no
Checking for TDS (Sybase)... no
Done running configuration tests.

Configure summary:

Qt Sql Drivers:
  DB2 (IBM) .............................. no
  InterBase .............................. no
  MySql .................................. no
  OCI (Oracle) ........................... yes
  ODBC ................................... yes
  PostgreSQL ............................. no
  SQLite2 ................................ no
  SQLite ................................. yes
    Using system provided SQLite ......... no
  TDS (Sybase) ........................... no

Qt is now configured for building. Just run 'nmake'.
Once everything is built, you must run 'nmake install'.
Qt will be installed into 'C:\Qt\5.15.2\msvc2019_64'.

Prior to reconfiguration, make sure you remove any leftovers from
the previous build.


C:\work\build\build-sqldrivers>nmake sub-oci

After building, there are qsqloci.dll and qsqlocid.dll in ..\plugins\sqldrivers.

About the machine type conflict, I think there is a chance that you have x86 nmake in your system PATH.
Try

1. Open a normal command prompt, run: echo %PATH%
   check is there any VS path in it
2. Open x64 Native tools Command Prompt, run: echo %PATH%
   check if the first VS path should be some MSVC 2015 with x64

[JoeBermejales]

@Bonnie Thanks for the detailed help, this is the normal console path variables. Will try to remove the last three in case it conflicts with the vs console environment vars

C:\app\jose_\product\21c\dbhomeXE\bin;
C:\Program Files\Common Files\Oracle\Java\javapath;
C:\Program Files\NVIDIA GPU Computing Toolkit\CUDA\v11.2\bin;
C:\Program Files\NVIDIA GPU Computing Toolkit\CUDA\v11.2\libnvvp;
C:\Users\jose_\AppData\Local\ActiveState\StateTool\release\bin;
C:\RoboDK\Python37\Scripts;
C:\RoboDK\Python37;
C:\Program Files (x86)\Common Files\Intel\Shared Libraries\redist\intel64\compiler;
C:\Windows\system32;
C:\Windows;
C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0;
C:\Windows\System32\OpenSSH;
C:\Program Files\NVIDIA Corporation\NVIDIA NvDLISR;
C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files\Git\cmd;
C:\Program Files\Gradle\gradle-5.6\bin;
C:\Program Files\AutoFirmaJA\AutoFirmaJA;
C:\Program Files\TortoiseSVN\bin;
C:\Users\jose_\AppData\Roaming\nvm;
C:\Program Files\nodejs;
C:\Program Files\PuTTY;
C:\Program Files\Java\jdk-11\bin;
C:\Program Files (x86)\IVI Foundation\VISA\WinNT\Bin;
C:\Program Files\IVI Foundation\VISA\Win64\Bin;
C:\Program Files (x86)\IVI Foundation\VISA\WinNT\Bin;
C:\Program Files\GenICam_v2_4\bin\Win64_x64;
C:\DeltaTa;
C:\Program Files (x86)\ZED SDK\dependencies\freeglut_2.8\x64;
C:\Program Files (x86)\ZED SDK\dependencies\glew-1.12.0\x64;
C:\Program Files (x86)\ZED SDK\dependencies\opencv_3.1.0\x64;
C:\Program Files (x86)\ZED SDK\bin;
C:\Users\jose_\AppData\Local\activestate\cache\bin;
C:\Users\jose_\AppData\Local\ActiveState\StateTool\release\bin;
C:\Users\jose_\AppData\Local\Programs\Python\Python311\Scripts;
C:\Users\jose_\AppData\Local\Programs\Python\Python311;
C:\Users\jose_\miniconda3;
C:\Users\jose_\miniconda3\Library\mingw-w64\bin;
C:\Users\jose_\miniconda3\Library\usr\bin;
C:\Users\jose_\miniconda3\Library\bin;
C:\Users\jose_\miniconda3\Scripts;
C:\Users\jose_\AppData\Local\Programs\Python\Python37-32\Scripts;
C:\Users\jose_\AppData\Local\Programs\Python\Python37-32;
C:\Users\jose_\AppData\Local\Microsoft\WindowsApps;
C:\Users\jose_\AppData\Local\Programs\Microsoft VS Code\bin;
C:\Users\jose_\AppData\Roaming\nvm;
C:\Program Files\nodejs;
C:\Users\jose_\AppData\Local\Google\Cloud SDK\google-cloud-sdk\bin;
C:\Users\jose_\AppData\Local\Android\Sdk\build-tools\30.0.3;
C:\msys64\usr\bin;
C:\PROYECTOS\P210901\bazel;
C:\Program Files\VideoLAN\VLC;
C:\Users\jose_\AppData\Roaming\npm;
C:\Program Files\NVIDIA GPU Computing Toolkit\CUDA\v11.2\libnvvp;
C:\Program Files\NVIDIA GPU Computing Toolkit\CUDA\v11.2\bin;
C:\msys64;
C:\msys64\usr\bin;
C:\Windows\System32;
**
C:\Qt\5.12.2\msvc2015_64\bin;
C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\bin;
C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\include;
C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\Tools;
**

And the VS2015 x64 Native Tools Command Prompt "echo %PATH%"

CommonExtensions\Microsoft\TestWindow
C:\Program Files (x86)\MSBuild\14.0\bin\amd64
C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\amd64
C:\WINDOWS\Microsoft.NET\Framework64\v4.0.30319
C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\VCPackages
C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE
C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\Tools
C:\Program Files (x86)\HTML Help Workshop
C:\Program Files (x86)\Microsoft Visual Studio 14.0\Team Tools\Performance Tools\x64
C:\Program Files (x86)\Microsoft Visual Studio 14.0\Team Tools\Performance Tools
C:\Program Files (x86)\Windows Kits\10\bin\x64
C:\Program Files (x86)\Windows Kits\10\bin\x86
C:\Program Files (x86)\Microsoft SDKs\Windows\v10.0A\bin\NETFX 4.6.1 Tools\x64
C:\app\jose_\product\21c\dbhomeXE\bin
C:\Program Files\Common Files\Oracle\Java\javapath
C:\Program Files\NVIDIA GPU Computing Toolkit\CUDA\v11.2\bin
C:\Program Files\NVIDIA GPU Computing Toolkit\CUDA\v11.2\libnvvp
C:\Users\jose_\AppData\Local\ActiveState\StateTool\release\bin
C:\RoboDK\Python37\Scripts
C:\RoboDK\Python37
C:\Program Files (x86)\Common Files\Intel\Shared Libraries\redist\intel64\compiler
C:\Windows\system32
C:\Windows
C:\Windows\System32\Wbem
C:\Windows\System32\WindowsPowerShell\v1.0
C:\Windows\System32\OpenSSH
C:\Program Files\NVIDIA Corporation\NVIDIA NvDLISR
C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common
C:\Program Files\Git\cmd
C:\Program Files\Gradle\gradle-5.6\bin
C:\Program Files\AutoFirmaJA\AutoFirmaJA
C:\Program Files\TortoiseSVN\bin
C:\Users\jose_\AppData\Roaming\nvm
C:\Program Files\nodejs
C:\Program Files\PuTTY
C:\Program Files\Java\jdk-11\bin
C:\Program Files (x86)\IVI Foundation\VISA\WinNT\Bin
C:\Program Files\IVI Foundation\VISA\Win64\Bin
C:\Program Files (x86)\IVI Foundation\VISA\WinNT\Bin
C:\Program Files\GenICam_v2_4\bin\Win64_x64
C:\DeltaTa
C:\Program Files (x86)\ZED SDK\dependencies\freeglut_2.8\x64
C:\Program Files (x86)\ZED SDK\dependencies\glew-1.12.0\x64
C:\Program Files (x86)\ZED SDK\dependencies\opencv_3.1.0\x64
C:\Program Files (x86)\ZED SDK\bin
C:\Users\jose_\AppData\Local\activestate\cache\bin
C:\Users\jose_\AppData\Local\ActiveState\StateTool\release\bin
C:\Users\jose_\AppData\Local\Programs\Python\Python311\Scripts
C:\Users\jose_\AppData\Local\Programs\Python\Python311
C:\Users\jose_\miniconda3
C:\Users\jose_\miniconda3\Library\mingw-w64\bin
C:\Users\jose_\miniconda3\Library\usr\bin
C:\Users\jose_\miniconda3\Library\bin
C:\Users\jose_\miniconda3\Scripts
C:\Users\jose_\AppData\Local\Programs\Python\Python37-32\Scripts
C:\Users\jose_\AppData\Local\Programs\Python\Python37-32
C:\Users\jose_\AppData\Local\Microsoft\WindowsApps
C:\Users\jose_\AppData\Local\Programs\Microsoft VS Code\bin
C:\Users\jose_\AppData\Roaming\nvm
C:\Program Files\nodejs
C:\Users\jose_\AppData\Local\Google\Cloud SDK\google-cloud-sdk\bin
C:\Users\jose_\AppData\Local\Android\Sdk\build-tools\30.0.3
C:\msys64\usr\bin
C:\PROYECTOS\P210901\bazel
C:\Program Files\VideoLAN\VLC
C:\Users\jose_\AppData\Roaming\npm
C:\Program Files\NVIDIA GPU Computing Toolkit\CUDA\v11.2\libnvvp
C:\Program Files\NVIDIA GPU Computing Toolkit\CUDA\v11.2\bin
C:\msys64
C:\msys64\usr\bin
C:\Windows\System32
C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\bin
C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\include
C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\Tools
C:\Qt\5.12.2\msvc2015_64\bin