Hello,
Jun 28, 2016 QSqlDatabase: QPSQL driver not loaded QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7 'Driver not loaded Driver not loaded' Although I followed all Qt deployment steps! OS: Windows 7 x64; Qt: 5.7; Postgres: 9.3.4-4-windows-x64; See files structure please. @nkbartc said in QSqlDatabase: QPSQL driver not loaded. I checked 'D: Qt 5.14.0 msvc201764 plugins sqldrivers qsqlpsqld.dll' and I did found the dll which the debugger reports as missing.
After installing Qt 5.3.0 under Windows 7 x64 I experienced a strange issue (Qt 5.2.1 was working fine).
I always get this error message:
[code]QSqlDatabase: QPSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7
Unable to connect![/code]
Whether I run my apps from Qt Creator or even deployed them as usual! The following list shows you that all the deployment files already exists while the app unable to find SQL plugin!... May I get a help from you?
[code]D:SnippetsC++ Qtbuild-SQLConnection-Desktop_Qt_5_3_0_MinGW_32bit-Debugdebug>dir /w /s
Volume in drive D is WORK
Volume Serial Number is 4585-4EFE
Directory of D:SnippetsC++ Qtbuild-SQLConnection-Desktop_Qt_5_3_0_MinGW_32bit-Debugdebug
[.] [..]
Enginio.dll Enginiod.dll
gpsvc.dll icudt52.dll
icuin52.dll icuuc52.dll
IEShims.dll libgcc_s_dw2-1.dll
libstdc++-6.dll libwinpthread-1.dll
main.o [platforms]
Qt5Bluetooth.dll Qt5Bluetoothd.dll
Qt5CLucene.dll Qt5CLucened.dll
Qt5Concurrent.dll Qt5Concurrentd.dll
Qt5Core.dll Qt5Cored.dll
Qt5Declarative.dll Qt5Declaratived.dll
Qt5Designer.dll Qt5DesignerComponents.dll
Qt5DesignerComponentsd.dll Qt5Designerd.dll
Qt5Gui.dll Qt5Guid.dll
Qt5Help.dll Qt5Helpd.dll
Qt5Multimedia.dll Qt5Multimediad.dll
Qt5MultimediaQuick_p.dll Qt5MultimediaQuick_pd.dll
Qt5MultimediaWidgets.dll Qt5MultimediaWidgetsd.dll
Qt5Network.dll Qt5Networkd.dll
Qt5Nfc.dll Qt5Nfcd.dll
Qt5OpenGL.dll Qt5OpenGLd.dll
Qt5Positioning.dll Qt5Positioningd.dll
Qt5PrintSupport.dll Qt5PrintSupportd.dll
Qt5Qml.dll Qt5Qmld.dll
Qt5Quick.dll Qt5Quickd.dll
Qt5QuickParticles.dll Qt5QuickParticlesd.dll
Qt5QuickTest.dll Qt5QuickTestd.dll
Qt5QuickWidgets.dll Qt5QuickWidgetsd.dll
Qt5Script.dll Qt5Scriptd.dll
Qt5ScriptTools.dll Qt5ScriptToolsd.dll
Qt5Sensors.dll Qt5Sensorsd.dll
Qt5SerialPort.dll Qt5SerialPortd.dll
Qt5Sql.dll Qt5Sqld.dll
Qt5Svg.dll Qt5Svgd.dll
Qt5Test.dll Qt5Testd.dll
Qt5WebKit.dll Qt5WebKitd.dll
Qt5WebKitWidgets.dll Qt5WebKitWidgetsd.dll
Qt5WebSockets.dll Qt5WebSocketsd.dll
Qt5Widgets.dll Qt5Widgetsd.dll
Qt5WinExtras.dll Qt5WinExtrasd.dll
Qt5Xml.dll Qt5Xmld.dll
Qt5XmlPatterns.dll Qt5XmlPatternsd.dll
SQLConnection.exe [sqldrivers]
sysntfy.dll
85 File(s) 754,574 bytes
Directory of D:SnippetsC++ Qtbuild-SQLConnection-Desktop_Qt_5_3_0_MinGW_32bit-Debugdebugplatforms
[.] [..] qminimal.dll qminimald.dll
qoffscreen.dll qoffscreend.dll qwindows.dll qwindowsd.dll
6 File(s) 22,739,714 bytes
Directory of D:SnippetsC++ Qtbuild-SQLConnection-Desktop_Qt_5_3_0_MinGW_32bit-Debugdebugsqldrivers
[.] [..] qsqlite.dll qsqlited.dll
qsqlmysql.dll qsqlmysqld.dll qsqlodbc.dll qsqlodbcd.dll
qsqlpsql.dll qsqlpsqld.dll
8 File(s) 6,147,884 bytes
D:SnippetsC++ Qtbuild-SQLConnection-Desktop_Qt_5_3_0_MinGW_32bit-Debugdebug>[/code]
PS
I copied SYSNTFY.DLL, IESHIMS.DLL and GPSVC.DLL because Dependency Walker mentioned them as dependent for my app.
Hi all,
I'm getting crazy with QMYSQL :(. I want to connet to a mysql server through this code (for testing the connection only). Qt version is 5.2.1, while OS is Ubuntu 13.10.
@
#include <QCoreApplication>
#include <QtSql/QSqlDatabase>
#include <QtSql/QSqlError>
#include <QDebug>
int main(int argc, char *argv[])
{
QCoreApplication a(argc, argv);
qDebug() << 'Started';
qDebug() << 'library path ' << a.libraryPaths();
}
@
I get the following output:
Started
library path ('/home/fabio/Qt/5.2.1/gcc/plugins', '/home/fabio/Tests/Qt/build-TestDatabase-Desktop_Qt_5_2_1_GCC_32bit-Debug')
('QSQLITE', 'QMYSQL', 'QMYSQL3', 'QPSQL', 'QPSQL7')
available = true
db error= 'Driver not loaded'
driver error= 'Driver not loaded'
done= false
Failed to open database
- db error= 'Driver not loaded'
- driver error= 'Driver not loaded'
Terminating
Qsqldatabase Qpsql Driver Not Loaded Using
As you can see, driver is not loaded, even if all libs are at the correct places and dependencies are satisfied.
This is the past of the plugin dependencies
fabio@ubuntu:~$ ldd /home/fabio/Qt/5.2.1/gcc/plugins/sqldrivers/libqsqlmysql.so
linux-gate.so.1 => (0xb77de000)
libmysqlclient.so.18 => /usr/lib/i386-linux-gnu/libmysqlclient.so.18 (0xb7492000)
libQt5Sql.so.5 => /home/fabio/Qt/5.2.1/gcc/lib/libQt5Sql.so.5 (0xb7453000)
libQt5Core.so.5 => /home/fabio/Qt/5.2.1/gcc/lib/libQt5Core.so.5 (0xb6f89000)
libstdc++.so.6 => /usr/lib/i386-linux-gnu/libstdc++.so.6 (0xb6ea0000)
libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xb6cec000)
libz.so.1 => /lib/i386-linux-gnu/libz.so.1 (0xb6cd2000)
libdl.so.2 => /lib/i386-linux-gnu/libdl.so.2 (0xb6ccd000)
libpthread.so.0 => /lib/i386-linux-gnu/libpthread.so.0 (0xb6cb1000)
libm.so.6 => /lib/i386-linux-gnu/libm.so.6 (0xb6c6e000)
libgcc_s.so.1 => /lib/i386-linux-gnu/libgcc_s.so.1 (0xb6c51000)
libicui18n.so.51 => /home/fabio/Qt/5.2.1/gcc/lib/libicui18n.so.51 (0xb6a2f000)
libicuuc.so.51 => /home/fabio/Qt/5.2.1/gcc/lib/libicuuc.so.51 (0xb68b6000)
libgthread-2.0.so.0 => /usr/lib/i386-linux-gnu/libgthread-2.0.so.0 (0xb68b2000)
librt.so.1 => /lib/i386-linux-gnu/librt.so.1 (0xb68a9000)
libglib-2.0.so.0 => /lib/i386-linux-gnu/libglib-2.0.so.0 (0xb67a5000)
/lib/ld-linux.so.2 (0xb77df000)
libicudata.so.51 => /home/fabio/Qt/5.2.1/gcc/lib/libicudata.so.51 (0xb525c000)
libpcre.so.3 => /lib/i386-linux-gnu/libpcre.so.3 (0xb521a000)
and, in the turn, the pasting of libmysqlclient which the plugin depends on:
fabio@ubuntu:~$ ldd /usr/lib/i386-linux-gnu/libmysqlclient.so.18
linux-gate.so.1 => (0xb773a000)
libz.so.1 => /lib/i386-linux-gnu/libz.so.1 (0xb73e6000)
libdl.so.2 => /lib/i386-linux-gnu/libdl.so.2 (0xb73e1000)
libpthread.so.0 => /lib/i386-linux-gnu/libpthread.so.0 (0xb73c5000)
libm.so.6 => /lib/i386-linux-gnu/libm.so.6 (0xb7382000)
libgcc_s.so.1 => /lib/i386-linux-gnu/libgcc_s.so.1 (0xb7365000)
libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xb71b1000)
/lib/ld-linux.so.2 (0xb773b000)
To be more precise, I have built the plugin directly from source code (5.2.1) and the database mentioned in the code really exists on 127.0.0.1.
Qsqldatabase Qpsql Driver Not Loaded
I also tried with QMYSQL3 (same result).
Qsqldatabase Qpsql Driver Not Loaded Linux
Qpsql Driver Not Loaded
I really don't know what else to check.
Please help me
Qsqldatabase Qpsql Driver Not Loaded Ubuntu
Thanks in advance
Fabio