Can't build QOCI driver

[OAmila]

When I try to connect my application with the Oracle database it gives an error saying
"QOCI driver not loaded"
So then I googled the error and found this answer in stackoverflow
https://stackoverflow.com/questions/29508725/qt-connect-to-oracle-database-on-windows
I followed every step in that answer but in the 5th step when I try to run command qmake oci.pro
it gives an error like this

how can I solve this???

[mrjj]

hi
Check that
set INCLUDE=%INCLUDE%;c:\app\user\product[version]\client_1\oci\include
set LIB=%LIB%;c:\app\user\product[version]\client_1\oci\lib\msvc
is 100% correct.
paste the path part to explore and see it can open location.

[OAmila]

@mrjj said in Can't build QOCI driver:

c:\app\user\product[version]\client_1\oci\include

Yes I have set both paths

[mrjj]

@OAmila
and check they are correct ? exists and can be opened?

[OAmila]

@mrjj
yes they are, when I tried this step using qt 5.20.0 it worked, but an error came in the next step where I had to run the command nmake

[SGaist]

Hi,

The instructions for building the SQL modules have changed. See Qt's documentation about the OCI driver.

[OAmila]

@SGaist

Thanks for pointing out the mistake, Now the qmake command runs without error, but when I run the nmake /oci command it prints many lines on the command prompt but nothing happens.

[aha_1980]

@OAmila you have a MinGW command prompt and want to use the MSVC compiler?! that cannot work...

[OAmila]

@aha_1980 thanks for helping, when I use mingw32-make it gives following error

[aha_1980]

hi @OAmila,

just read the big warning message. MinGW seems not supported with Oracle.

Sorry

[OAmila]

@aha_1980 So does that mean I can't connect my Qt application with an Oracle database? will I be able to do it if I use an older Qt version. Why don't they include it in the documentation :( :( I already spent around a week resolving this, anyway thanks a lot for helping

[aha_1980]

@OAmila

It means, that it does not work with MinGW - you can ask Oracle to better support that compiler.

But it seems you can use the MSVC compiler with a suitable Qt for your app.

Regards

[OAmila]

@aha_1980 Ok thanks a lot for helping
Regards,