How to install QPSQL drivers?

Question

I was trying to make connection to my PSQL database but when I checked:

dbliste = QtSql.QSqlDatabase.drivers()  print(dbliste),

i got this:

['QSQLITE', 'QODBC', 'QODBC3']

Why I don't have drivers for QPSQL installed? Where can I download them?

from PyQt5 import QtWidgets, QtSql

def createConnection():
    db = QtSql.QSqlDatabase.addDatabase("QPSQL")
    db.setHostName('localhost') 
    db.setPort(5432) 
    db.setDatabaseName('DB_real') 
    db.setUserName('postgres') 
    db.setPassword('****') 


if not db.open():
    QtWidgets.QMessageBox.critical(None, "Cannot open database",
                         "Unable to establish a database connection.\n"

                         "Click Cancel to exit.", QtWidgets.QMessageBox.Cancel)
    return False

dbliste = QtSql.QSqlDatabase.drivers() 
print(dbliste)

try with https://stackoverflow.com/questions/26507353/qpsql-driver-not-loaded-qt — eyllanesc, Jan 03 '19 at 13:05

score 0 · Answer 1 · answered Jan 03 '19 at 18:12

0

I found out that first problem was in different version of PostgreSQL and QT. Now I am deinstalling and installing the right versions and then I will try to connect it. I hope it works...

answered Jan 03 '19 at 18:12

user10807076

31
7

I tried, and no succes.... I added PATH, copied .dll, copied directory sqldrives and still nothing – user10807076 Jan 03 '19 at 21:00

user10807076 · Accepted Answer · 2019-01-03T22:18:00.237

0

Simple solution after two days is just to install 'Pyqt5' using pip even if is already installed with conda or installer:

pip install PyQt5

edited Jan 03 '19 at 22:18

answered Jan 03 '19 at 21:47

user10807076

31
7

How to install QPSQL drivers?

2 Answers2

Linked

Related