PyQt5 Sqlite - no available drivers

[aseroth]

Hello. I'm having a problem trying to create database file using sqlite. I keep getting error
" QSqlDatabase: QSQLITE driver not loaded
QSqlDatabase: available drivers: "

My setup:
Windows 11
Python 3.9.7
PyQt5 installed via pip

[eyllanesc]

@aseroth It is strange what you point out, by default the sqlite driver is included. Could you provide a minimal and verifiable example of your code as well as showing the log when you run: QT_DEBUG_PLUGINS=1 python script.py

[aseroth]

Here's my code:

from PyQt5 import QtCore, QtGui, QtWidgets
from PyQt5 import QtSql
from PyQt5.QtSql import  QSqlDatabase, QSqlQuery


def create_db():
    conn = QtSql.QSqlDatabase.addDatabase('QSQLITE')
    conn.setDatabaseName("bazadanych")

class Ui_MainWindow(object):
    def setupUi(self, MainWindow):
        MainWindow.setObjectName("MainWindow")
        MainWindow.resize(416, 503)
        self.centralwidget = QtWidgets.QWidget(MainWindow)
        self.centralwidget.setObjectName("centralwidget")
        self.nameEdit = QtWidgets.QLineEdit(self.centralwidget)
        self.nameEdit.setGeometry(QtCore.QRect(10, 10, 161, 20))
        self.nameEdit.setObjectName("nameEdit")
        self.adresEdit = QtWidgets.QLineEdit(self.centralwidget)
        self.adresEdit.setGeometry(QtCore.QRect(10, 40, 161, 20))
        self.adresEdit.setObjectName("adresEdit")
        self.insurEdit = QtWidgets.QLineEdit(self.centralwidget)
        self.insurEdit.setGeometry(QtCore.QRect(10, 70, 161, 20))
        self.insurEdit.setObjectName("insurEdit")
        self.phoneEdit = QtWidgets.QLineEdit(self.centralwidget)
        self.phoneEdit.setGeometry(QtCore.QRect(10, 100, 161, 20))
        self.phoneEdit.setObjectName("phoneEdit")
        self.mailEdit = QtWidgets.QLineEdit(self.centralwidget)
        self.mailEdit.setGeometry(QtCore.QRect(10, 130, 161, 20))
        self.mailEdit.setObjectName("mail")
        self.zawarcie = QtWidgets.QDateEdit(self.centralwidget)
        self.zawarcie.setGeometry(QtCore.QRect(10, 160, 110, 22))
        self.zawarcie.setObjectName("zawarcie")
        self.ubezpOd = QtWidgets.QDateEdit(self.centralwidget)
        self.ubezpOd.setGeometry(QtCore.QRect(10, 190, 110, 22))
        self.ubezpOd.setObjectName("ubezpOd")
        self.firmy = QtWidgets.QComboBox(self.centralwidget)
        self.firmy.setGeometry(QtCore.QRect(10, 250, 111, 22))
        self.firmy.setCurrentText("")
        self.firmy.setMaxVisibleItems(10)
        self.firmy.setObjectName("firmy")
        self.typUbezp = QtWidgets.QComboBox(self.centralwidget)
        self.typUbezp.setGeometry(QtCore.QRect(10, 280, 111, 22))
        self.typUbezp.setObjectName("typUbezp")
        self.raty = QtWidgets.QSpinBox(self.centralwidget)
        self.raty.setGeometry(QtCore.QRect(10, 340, 111, 22))
        self.raty.setMinimum(1)
        self.raty.setMaximum(12)
        self.raty.setObjectName("raty")
        self.platnosc = QtWidgets.QComboBox(self.centralwidget)
        self.platnosc.setGeometry(QtCore.QRect(10, 310, 111, 22))
        self.platnosc.setObjectName("platnosc")
        self.ubezpDo = QtWidgets.QDateEdit(self.centralwidget)
        self.ubezpDo.setGeometry(QtCore.QRect(10, 220, 110, 22))
        self.ubezpDo.setObjectName("ubezpDo")
        self.Zapisz = QtWidgets.QPushButton(self.centralwidget)
        self.Zapisz.setGeometry(QtCore.QRect(300, 10, 75, 23))
        self.Zapisz.setObjectName("Zapisz")
        self.clear = QtWidgets.QPushButton(self.centralwidget)
        self.clear.setGeometry(QtCore.QRect(300, 50, 75, 23))
        self.clear.setObjectName("clear")
        self.zamknij = QtWidgets.QPushButton(self.centralwidget)
        self.zamknij.setGeometry(QtCore.QRect(300, 90, 75, 23))
        self.zamknij.setObjectName("zamknij")
        self.zawarcieLabel = QtWidgets.QLabel(self.centralwidget)
        self.zawarcieLabel.setGeometry(QtCore.QRect(130, 160, 81, 16))
        self.zawarcieLabel.setObjectName("zawarcieLabel")
        self.okresOdLabel = QtWidgets.QLabel(self.centralwidget)
        self.okresOdLabel.setGeometry(QtCore.QRect(130, 190, 91, 16))
        self.okresOdLabel.setObjectName("okresOdLabel")
        self.okresDoLabel = QtWidgets.QLabel(self.centralwidget)
        self.okresDoLabel.setGeometry(QtCore.QRect(130, 220, 91, 16))
        self.okresDoLabel.setObjectName("okresDoLabel")
        self.firmyLabel = QtWidgets.QLabel(self.centralwidget)
        self.firmyLabel.setGeometry(QtCore.QRect(130, 250, 71, 16))
        self.firmyLabel.setObjectName("firmyLabel")
        self.typUbezpLabel = QtWidgets.QLabel(self.centralwidget)
        self.typUbezpLabel.setGeometry(QtCore.QRect(130, 280, 111, 16))
        self.typUbezpLabel.setObjectName("typUbezpLabel")
        self.platnoscLabel = QtWidgets.QLabel(self.centralwidget)
        self.platnoscLabel.setGeometry(QtCore.QRect(130, 310, 101, 16))
        self.platnoscLabel.setObjectName("platnoscLabel")
        self.ratyLabel = QtWidgets.QLabel(self.centralwidget)
        self.ratyLabel.setGeometry(QtCore.QRect(130, 340, 71, 16))
        self.ratyLabel.setObjectName("ratyLabel")
        MainWindow.setCentralWidget(self.centralwidget)
        self.statusbar = QtWidgets.QStatusBar(MainWindow)
        self.statusbar.setObjectName("statusbar")
        MainWindow.setStatusBar(self.statusbar)

        self.retranslateUi(MainWindow)
        QtCore.QMetaObject.connectSlotsByName(MainWindow)

       
        createTableKlienci = QSqlQuery()
        createTableKlienci.exec(
            """
            CREATE TABLE IF NOT EXISTS klienci(
                id INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE NOT NULL,
                name VARCHAR(100) NOT NULL,
                adres VARCHAR(100) NOT NULL,
                mail VARCHAR(100) NOT NULL,
                telefon VARCHAR(100) NOT NULL,
                polisa VARCHAR(100) NOT NULL,
                zawarcie VARCHAR(100) NOT NULL,
                dataod VARCHAR(100) NOT NULL,
                datado VARCHAR(100) NOT NULL,
            )
            """
        )
        
        self.Zapisz.clicked.connect(self.clickedZapisz)
        self.zamknij.clicked.connect(self.clickedZamknij)
            


    def retranslateUi(self, MainWindow):
        _translate = QtCore.QCoreApplication.translate
        MainWindow.setWindowTitle(_translate("MainWindow", "MainWindow"))
        self.nameEdit.setText(_translate("MainWindow", "Imie, nazwisko / Nazwa"))
        self.adresEdit.setText(_translate("MainWindow", "Adres"))
        self.mailEdit.setText(_translate("MainWindow", "Mail"))
        self.phoneEdit.setText(_translate("MainWindow", "Telefon"))
        self.insurEdit.setText(_translate("MainWindow", "Nr polisy"))
        self.Zapisz.setText(_translate("MainWindow", "Zapisz"))
        self.clear.setText(_translate("MainWindow", "Wyczyść"))
        self.zamknij.setText(_translate("MainWindow", "Zamknij"))
        self.zawarcieLabel.setText(_translate("MainWindow", "Data zawarcia"))
        self.okresOdLabel.setText(_translate("MainWindow", "Ubezpieczenie Od"))
        self.okresDoLabel.setText(_translate("MainWindow", "Ubezpieczenie Do"))
        self.firmyLabel.setText(_translate("MainWindow", "Towarzystwo"))
        self.typUbezpLabel.setText(_translate("MainWindow", "Rodzaj ubezpieczenia"))
        self.platnoscLabel.setText(_translate("MainWindow", "Forma płatności"))
        self.ratyLabel.setText(_translate("MainWindow", "Liczba rat"))
    
    def clickedZapisz(self):
        dane = QSqlQuery()
        dane.exec(f"""INSERT INTO klienci (name, adres, mail, telefon, polisa, zawarcie, dataod, datado) VALUES ('{self.nameEdit.text()}, {self.adresEdit.text()}, {self.mailEdit.text()}, {self.phoneEdit.text()}, {self.insurEdit.text()}, {self.zawarcie.text()}, {self.ubezpOd.text()}, {self.ubezpDo.text()}""")
       
    def clickedZamknij(self):
        sys.exit(1)

if __name__ == "__main__":
    import sys
    app = QtWidgets.QApplication(sys.argv)
    create_db()
    MainWindow = QtWidgets.QMainWindow()
    ui = Ui_MainWindow()
    ui.setupUi(MainWindow)
    MainWindow.show()
    sys.exit(app.exec_())

Output from QT_DEBUG_PLUGINS=1

D:\Python>QT_DEBUG_PLUGINS=1 python d:\python\kliencijson.py
'QT_DEBUG_PLUGINS' is not recognized as an internal or external command,
operable program or batch file.

[JonB]

@aseroth

set QT_DEBUG_PLUGINS=1
python d:\python\kliencijson.py

[aseroth]

@JonB said in PyQt5 Sqlite - no available drivers:

set QT_DEBUG_PLUGINS=1
python d:\python\kliencijson.py

Here's the output

QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms" ...
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qminimal.dll"
Found metadata in lib C:/Users/Bart?omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qminimal.dll, metadata=
{
    "IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3",
    "MetaData": {
        "Keys": [
            "minimal"
        ]
    },
    "archreq": 0,
    "className": "QMinimalIntegrationPlugin",
    "debug": false,
    "version": 331520
}


Got keys from plugin meta data ("minimal")
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qoffscreen.dll"
Found metadata in lib C:/Users/Bart?omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qoffscreen.dll, metadata=
{
    "IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3",
    "MetaData": {
        "Keys": [
            "offscreen"
        ]
    },
    "archreq": 0,
    "className": "QOffscreenIntegrationPlugin",
    "debug": false,
    "version": 331520
}


Got keys from plugin meta data ("offscreen")
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qwebgl.dll"
Found metadata in lib C:/Users/Bart?omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qwebgl.dll, metadata=
{
    "IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3",
    "MetaData": {
        "Keys": [
            "webgl"
        ]
    },
    "archreq": 0,
    "className": "QWebGLIntegrationPlugin",
    "debug": false,
    "version": 331520
}


Got keys from plugin meta data ("webgl")
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qwindows.dll"
Found metadata in lib C:/Users/Bart?omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qwindows.dll, metadata=
{
    "IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3",
    "MetaData": {
        "Keys": [
            "windows"
        ]
    },
    "archreq": 0,
    "className": "QWindowsIntegrationPlugin",
    "debug": false,
    "version": 331520
}


Got keys from plugin meta data ("windows")
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39" ...
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/python3.dll"
"Failed to extract plugin meta data from 'C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/python3.dll'"
         not a plugin
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/python39.dll"
"Failed to extract plugin meta data from 'C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/python39.dll'"
         not a plugin
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/vcruntime140.dll"
"Failed to extract plugin meta data from 'C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/vcruntime140.dll'"
         not a plugin
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/vcruntime140_1.dll"
"Failed to extract plugin meta data from 'C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/vcruntime140_1.dll'"
         not a plugin
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/platforms" ...
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/platforms" ...
loaded library "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qwindows.dll"
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms" ...
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qminimal.dll"
Got keys from plugin meta data ()
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qoffscreen.dll"
Got keys from plugin meta data ()
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qwebgl.dll"
Got keys from plugin meta data ()
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qwindows.dll"
Got keys from plugin meta data ()
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39" ...
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/python3.dll"
"Failed to extract plugin meta data from 'C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/python3.dll'"
         not a plugin
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/python39.dll"
"Failed to extract plugin meta data from 'C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/python39.dll'"
         not a plugin
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/vcruntime140.dll"
"Failed to extract plugin meta data from 'C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/vcruntime140.dll'"
         not a plugin
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/vcruntime140_1.dll"
"Failed to extract plugin meta data from 'C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/vcruntime140_1.dll'"
         not a plugin
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/platformthemes" ...
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/platformthemes" ...
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/styles" ...
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/styles" ...
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/sqldrivers" ...
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/sqldrivers" ...
QSqlDatabase: QSQLITE driver not loaded
QSqlDatabase: available drivers:
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/accessible" ...
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/accessible" ...
QSqlQuery::exec: database not open
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/accessiblebridge" ...
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/accessiblebridge" ...
QLibraryPrivate::unload succeeded on "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qwindows.dll"

D:\Python>

[eyllanesc]

@aseroth Could you take a screenshot of folder C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/sqldrivers?

[aseroth]

Ha, funny thing, there is not such folder in C:/Users/Bartłomiej Nowak/AppData/Local/Programs/Python/Python39/, but there is C:\Users\Bartłomiej Nowak\AppData\Local\Programs\Python\Python39\Lib\site-packages\PyQt5\Qt5\plugins\sqldrivers containing qsqlite.dll, qsqlodbc.dll and qsqlpsql.dll

[aseroth]

Ok, i've created sqldrivers folder in Pyhon39 and did rerun my script, here's the output

QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms" ...
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qminimal.dll"
Found metadata in lib C:/Users/Bart?omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qminimal.dll, metadata=
{
    "IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3",
    "MetaData": {
        "Keys": [
            "minimal"
        ]
    },
    "archreq": 0,
    "className": "QMinimalIntegrationPlugin",
    "debug": false,
    "version": 331520
}


Got keys from plugin meta data ("minimal")
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qoffscreen.dll"
Found metadata in lib C:/Users/Bart?omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qoffscreen.dll, metadata=
{
    "IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3",
    "MetaData": {
        "Keys": [
            "offscreen"
        ]
    },
    "archreq": 0,
    "className": "QOffscreenIntegrationPlugin",
    "debug": false,
    "version": 331520
}


Got keys from plugin meta data ("offscreen")
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qwebgl.dll"
Found metadata in lib C:/Users/Bart?omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qwebgl.dll, metadata=
{
    "IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3",
    "MetaData": {
        "Keys": [
            "webgl"
        ]
    },
    "archreq": 0,
    "className": "QWebGLIntegrationPlugin",
    "debug": false,
    "version": 331520
}


Got keys from plugin meta data ("webgl")
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qwindows.dll"
Found metadata in lib C:/Users/Bart?omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qwindows.dll, metadata=
{
    "IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3",
    "MetaData": {
        "Keys": [
            "windows"
        ]
    },
    "archreq": 0,
    "className": "QWindowsIntegrationPlugin",
    "debug": false,
    "version": 331520
}


Got keys from plugin meta data ("windows")
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39" ...
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/python3.dll"
"Failed to extract plugin meta data from 'C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/python3.dll'"
         not a plugin
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/python39.dll"
"Failed to extract plugin meta data from 'C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/python39.dll'"
         not a plugin
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/vcruntime140.dll"
"Failed to extract plugin meta data from 'C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/vcruntime140.dll'"
         not a plugin
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/vcruntime140_1.dll"
"Failed to extract plugin meta data from 'C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/vcruntime140_1.dll'"
         not a plugin
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/platforms" ...
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/platforms" ...
loaded library "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qwindows.dll"
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms" ...
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qminimal.dll"
Got keys from plugin meta data ()
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qoffscreen.dll"
Got keys from plugin meta data ()
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qwebgl.dll"
Got keys from plugin meta data ()
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qwindows.dll"
Got keys from plugin meta data ()
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39" ...
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/python3.dll"
"Failed to extract plugin meta data from 'C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/python3.dll'"
         not a plugin
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/python39.dll"
"Failed to extract plugin meta data from 'C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/python39.dll'"
         not a plugin
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/vcruntime140.dll"
"Failed to extract plugin meta data from 'C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/vcruntime140.dll'"
         not a plugin
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/vcruntime140_1.dll"
"Failed to extract plugin meta data from 'C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/vcruntime140_1.dll'"
         not a plugin
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/platformthemes" ...
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/platformthemes" ...
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/styles" ...
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/styles" ...
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/sqldrivers" ...
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/sqldrivers" ...
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/sqldrivers/qsqlite.dll"
Found metadata in lib C:/Users/Bart?omiej Nowak/AppData/Local/Programs/Python/Python39/sqldrivers/qsqlite.dll, metadata=
{
    "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
    "MetaData": {
        "Keys": [
            "QSQLITE"
        ]
    },
    "archreq": 0,
    "className": "QSQLiteDriverPlugin",
    "debug": false,
    "version": 331520
}


Got keys from plugin meta data ("QSQLITE")
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/sqldrivers/qsqlodbc.dll"
Found metadata in lib C:/Users/Bart?omiej Nowak/AppData/Local/Programs/Python/Python39/sqldrivers/qsqlodbc.dll, metadata=
{
    "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
    "MetaData": {
        "Keys": [
            "QODBC3",
            "QODBC"
        ]
    },
    "archreq": 0,
    "className": "QODBCDriverPlugin",
    "debug": false,
    "version": 331520
}


Got keys from plugin meta data ("QODBC3", "QODBC")
QFactoryLoader::QFactoryLoader() looking at "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/sqldrivers/qsqlpsql.dll"
Found metadata in lib C:/Users/Bart?omiej Nowak/AppData/Local/Programs/Python/Python39/sqldrivers/qsqlpsql.dll, metadata=
{
    "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
    "MetaData": {
        "Keys": [
            "QPSQL7",
            "QPSQL"
        ]
    },
    "archreq": 0,
    "className": "QPSQLDriverPlugin",
    "debug": false,
    "version": 331520
}


Got keys from plugin meta data ("QPSQL7", "QPSQL")
loaded library "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/sqldrivers/qsqlite.dll"
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/accessible" ...
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/accessible" ...
QSqlQuery::exec: database not open
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/accessiblebridge" ...
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/accessiblebridge" ...
QLibraryPrivate::unload succeeded on "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/sqldrivers/qsqlite.dll"
QLibraryPrivate::unload succeeded on "C:/Users/Bart│omiej Nowak/AppData/Local/Programs/Python/Python39/Lib/site-packages/PyQt5/Qt5/plugins/platforms/qwindows.dll"

under VSC the result is

PS D:\Python> & "C:/Users/Bartłomiej Nowak/AppData/Local/Programs/Python/Python39/python.exe" d:/Python/kliencijson.py
QSqlQuery::exec: database not open

here it doe's not show error about missing drivers BUT, i've created another simple script

from PyQt5 import QtCore, QtGui, QtWidgets
from PyQt5 import QtSql
from PyQt5.QtSql import  QSqlDatabase, QSqlQuery

con = QSqlDatabase.addDatabase("QSQLITE")
con.setDatabaseName("test")

con

and the outcome in VSC

PS D:\Python> & "C:/Users/Bartłomiej Nowak/AppData/Local/Programs/Python/Python39/python.exe" d:/Python/tetsy.py
QSqlDatabase: QSQLITE driver not loaded
QSqlDatabase: available drivers: 
QSqlDatabase: an instance of QCoreApplication is required for loading driver plugins

[JonB]

@aseroth said in PyQt5 Sqlite - no available drivers:

QSqlDatabase: an instance of QCoreApplication is required for loading driver plugins

In a Qt program you must first create an instance of QCoreApplication, or a class derived from it (QGuiApplication, QApplication), before you do anything like try to access QSqlDatabase.