ODBC driver not loaded but ODBC is available according to QSqlDatabase class



  • Hi all i'm Cristiano
    i'm trying to read an xls file for handling its content and put it as i prefer. As suggested in the documentation , i'm trying to use the SqlDatabase object with the "ODBC" driver. I hence had downloaded the qtbase source code for my qt version, i have compiled the plugin using the unixODBC libraries and all has gone well. I have then copied the libqsqlodbc.so in the right position and now i can see a new driver in my project. The probelm is very strange: when i call

    QSqlDatabase::addDatabase("QODBC")
    

    the console shows me this strange message:

    QSqlDatabase: QODBC driver not loaded
    QSqlDatabase: available drivers: QSQLITE QSQLITE3 QODBC QODBC3 ...
    

    what's the problem?

    P.S.: i'm using Qt5.5.1 on a unix 32 bit machine.

    Thanks to all

    Regards

    Cristiano



  • Hi, I got the libqsqlodbc.so plugin to load successfully, I think it was last year with Qt 5.2 or 5.3, but I remember I had same kind of difficulties because the libqsqlodbc.so plugin is depending on libodbc.so being in the correct place. You could check with
    ldd libqsqlodbc.so
    to see what .so files are missing..


Log in to reply
 

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