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 callQSqlDatabase::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..