[SOLVED] connect oracle database from qt creator



  • Hi everyone

    On windows platform I am trying to connect oracle database but i have an error QSqlDatabase: QOCI driver not loaded.
    I installer oracle client and pl/sql developer on my machine and everything works fine. Also i read qt documentation but it didn't help me. Is there up to date clear tutorial how to install oci plugin on windows(and on every platform)?

    Please Help



  • Hi,

    are the oci.dll in the PATH??



  • Did you mean PATH in Environment Variables? yes they are.



  • Ok,

    I remember I had some issues in the past to setup OCI Qt drivers on Windows but I don't remember how solved them (sorry).

    Now I'm on a Mac and I'm not using anymore Windows (sorry again).

    Is the driver built and installed correctly?

    QSqlDatabase::drivers()
    

    shows the QOCI driver??



  • Yes I tried, output is QSQLITE, QODBC, QODBC3



  • Ok. I found solution.
    Documentation says

    set INCLUDE=%INCLUDE%;c:\oracle\oci\include
    set LIB=%LIB%;c:\oracle\oci\lib\msvc
    cd %QTDIR%\src\plugins\sqldrivers\oci
    qmake oci.pro
    nmake

    If you are not using a Microsoft compiler, replace nmake with make in the line above.

    but make or nmake didn't work for me. Because I have not installed Microsoft Visual c++ on my machine.

    I made instruction how to do this:

    1 . At first don't forget to install qt sources. During the installation check Sources checkbox.

    2 . then download and install oracle client win32_11gR2_client.zip. choose Runtime option during installation.(even if you are using 64 bit os download 32 bit version on oracle client). It creates c:\app\user\product\client_1... directory

    3 . then open qt minGW command line(start ->all programs -> qt[version] -> [version] -> MinGW [version] -> Qt [version] for Desktop MinGW [version]) and move to the oci source folder:
    cd C:\Qt\Qt[version][version]\Src\qtbase\src\plugins\sqldrivers\oci

    4 . then as documentation says include OCI(Oracle call interface) path and library:
    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

    5 . compile oci driver by executing these two lines:
    qmake oci.pro
    mingw32-make
    it will creates two .dll files for you qsqloci.dll(release version) and qsqlocid.dll(debug version)

    6 . last step is to copy these two files into qtcreator installation folder. go to the:
    C:\Qt\Qt[version][version]\Src\qtbase\plugins\sqldrivers
    and copy these files into:
    C:\Qt\Qt[version][version]\mingw[version]\plugins\sqldrivers

    and you are ready to go. to check connection try this code:

    #include <QCoreApplication>
    #include <QtSql>
    #include <QDebug>
    
    int main(int argc, char *argv[])
    {
        QCoreApplication a(argc, argv);
    
        QSqlDatabase db = QSqlDatabase::addDatabase("QOCI");
        db.setHostName("MY_IP_OR_HOST_NAME");
        db.setDatabaseName("XE");
        db.setUserName("test");
        db.setPassword("test_password");
    
        if (!db.open())
        {
            qDebug() << db.lastError().text();
        }
        else{
            qDebug() << "Wow opened";
        }
    
        return a.exec();
    }
    

Log in to reply
 

Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.