Compiling in Windows 10 with Oracle support

[diegosps]

Hello.

I was able to build it in Visual Studio 2017 doing some changes at the scripts.
However, I can't get any oracle support. The button is not present at the layer browser windows and in DB Manager I get this error:

2020-03-03T14:20:48     CRITICAL    Qt : QSqlDatabase: QOCISPATIAL driver not loaded
2020-03-03T14:20:48     CRITICAL    Qt : QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7

There is also other erros:

2020-03-03T17:33:58     WARNING    Falha ao carregar D:/workspace/github/QGIS/ms-windows/osgeo4w/build-qgis-test-x86_64/output/plugins/RelWithDebInfo/grassplugin7.dll (Razão: Cannot load library D:\workspace\github\QGIS\ms-windows\osgeo4w\build-qgis-test-x86_64\output\plugins\RelWithDebInfo\grassplugin7.dll: Não foi possível encontrar o módulo especificado.)
2020-03-03T17:33:58     WARNING    Falha ao carregar D:/workspace/github/QGIS/ms-windows/osgeo4w/build-qgis-test-x86_64/output/plugins/RelWithDebInfo/grassprovider7.dll (Razão: Cannot load library D:\workspace\github\QGIS\ms-windows\osgeo4w\build-qgis-test-x86_64\output\plugins\RelWithDebInfo\grassprovider7.dll: Não foi possível encontrar o módulo especificado.)
2020-03-03T17:33:59     WARNING    Falha ao carregar D:/workspace/github/QGIS/ms-windows/osgeo4w/build-qgis-test-x86_64/output/plugins/RelWithDebInfo/grassrasterprovider7.dll (Razão: Cannot load library D:\workspace\github\QGIS\ms-windows\osgeo4w\build-qgis-test-x86_64\output\plugins\RelWithDebInfo\grassrasterprovider7.dll: Não foi possível encontrar o módulo especificado.)
2020-03-03T17:33:59     WARNING    Falha ao carregar D:/workspace/github/QGIS/ms-windows/osgeo4w/build-qgis-test-x86_64/output/plugins/RelWithDebInfo/qgisgrass7.dll (Razão: Cannot load library D:\workspace\github\QGIS\ms-windows\osgeo4w\build-qgis-test-x86_64\output\plugins\RelWithDebInfo\qgisgrass7.dll: Não foi possível encontrar o módulo especificado.)

2020-03-03T17:33:59     WARNING    Erro Python : Impossível carregar complemento 'MetaSearch' Devido a um erro ao chamar o método Class Factory(). Consulte o registro de mensagens (Erro Python) para mais detalhes.
2020-03-03T17:33:59     WARNING    Complemento processing : O complemento será desabilitado porque ele fechou o QGIS durante seu último início. Por favor, reporte um erro e reabilite o complemento quando o problema estiver resolvido.
2020-03-03T17:33:59     CRITICAL    Qt : QString::arg: 9 argument(s) missing in O estado do aplicativo: 
             QGIS_PREFIX_PATH env var: ??% 1 
             Prefixo: ??% 2 
             Caminho do Complemento: ??% 3 
             Caminho de Dados Pacote: ?% 4 
             Ativo Theme Name: ?% 5 
             Caminho Tema ativo: ?% 6 
             Tema Padr�o Caminho: ?% 7 
             SVG caminhos de pesquisa: ?% 8 
             Usu�rio DB Path: ?% 9 
             Auth DB Path: ?% 10

I used these instructions. And also looked here. But no luck.

Now I'm trying different oracle parameters when creating the vs solution.

I don't have Oracle Client installed at my machine. But if you go to their website, you can see they now provide the OCI dlls without any installation at all.

At my last attempt, I download the latest version and tried to generate the visual studio solution with the following parameters in msvc-env.bat:

path %PATH%;D:\Ferramentas\oracle_instant_client\instantclient_19_5
set OCI_INCLUDEDIR=D:\Ferramentas\oracle_instant_client\instantclient_19_5
set OCI_INCDIR=D:\Ferramentas\oracle_instant_client\instantclient_19_5
set OCI_LIBDIR=D:\Ferramentas\oracle_instant_client\instantclient_19_5
set ORACLE_HOME=D:\Ferramentas\oracle_instant_client\instantclient_19_5
set ORACLE_INCLUDEDIR=D:\Ferramentas\oracle_instant_client\instantclient_19_5
set ORACLE_LIBDIR=D:\Ferramentas\oracle_instant_client\instantclient_19_5

Also in qgis\CMakeList.txt I did this edit:

IF(WITH_ORACLE)
    SET(HAVE_ORACLE TRUE)
    SET(ORACLE_INCLUDEDIR ${ORACLE_INCLUDEDIR} CACHE STRING "Path to OCI headers")
    SET(ORACLE_LIBDIR ${ORACLE_LIBDIR} CACHE STRING "Path to OCI libraries")
  ENDIF(WITH_ORACLE)

To be able to compile and run the program in visual studio, I had to copy all qt5 dlls, proj_7_1.dll and gdal301.dll to the output diretocry.

I also noticed that \OSGeo4W\apps\Qt5\plugins\sqldrivers does not have the OCI driver.

Anyway, can someone point me exactly what I have to do to build qgis in windows with oracle support? I need to fix this issue

Thanks

[nyalldawson]

This is a question for the mailing list or stackexchange, not the bug tracker