QSqlDatabase: QPSQL driver not loaded, Qt 5.10.1 (x8664-littleendian-lp64 shared (dynamic) release build; by GCC 5.3. 1 20160406 (Red Hat 5.3.1-6)) on 'xcb' OS: Ubuntu 17.10 QSqlDatabase: QPSQL driver not loaded QSqlDatabase: available drivers: QSQLITE QODBC QODBC3 QPSQL QPSQL7 – Juhhi Sep 8 '13 at 13:43 You still have parts, which try to.
Note: Some drivers, such as the QPSQL driver, may may require you to pass tablename in lower case if the table was not quoted when created. See the Qt SQL driver documentation for more information. static void QSqlDatabase:: registerSqlDriver (const QString & name, QSqlDriverCreatorBase. creator ).
QSqlDatabase: QOCI driver not loaded QSqlDatabase: available drivers: QSQLITE QIBASE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7 QSqlQuery::exec: database not open Of course, not enough libraries to work with Oracle. Only managed to Google the name Liby: libqsqloci.so Question: where it to take? Not banned in Google, but found he couldn't.

QSqlDatabase: QPSQL driver not loaded QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7 Could not create database object While navigating the results in forward-only mode, the handle of QSqlResult may change. PyQt5 QMYSQL Driver not loaded, mysql-connector: pip install mysql-connector (2.2.9). And but the driver I compiled before in the sqldrivers folder from PyQt5, because the driver QSqlDatabase: QMYSQL driver not loaded QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7 I am using Windows 10, MySql 8, Python 3.7.

I’m trying to connect to a PostgreSQL 13 database from PyQt/PySide.

When I get to con = QSqlDatabase.addDatabase('QPSQL'), I get the following console output:

The second line, as far as I can tell, shows the QPSQL driver is found, but for some reason it’s not loading.

I’ve scoured the internet, and tried copying DLLs around the place, as well as adding various directories to my system PATH, but haven’t found a solution.

I’ve tried PyQt5, PyQt6, PySide2, and PySide6, all in fresh venvs, all have had the same issue. If I simply change the driver string to 'QSQLITE', the driver loads successfully (though, obviously, the script subsequently runs into errors, as I’m not using SQLite).

I tried this on two Win10 machines and a Win7 machine, all had the same issue, though when I tried it on my Mac, it worked first try, no fiddling required.

I can’t for the life of me figure out what’s going on! Any help would be greatly appreciated.

Source: Python Questions

The QSqlDatabase class handles a connection to a database. More...

Public Functions

QSqlDatabase(const QSqlDatabase &other)
QSqlDatabase()
QSqlDatabase &	operator=(const QSqlDatabase &other)
~QSqlDatabase()
void	close()
bool	commit()
QString	connectOptions() const
QString	connectionName() const
QString	databaseName() const
QSqlDriver *	driver() const
QString	driverName() const
QSqlQuery	exec(const QString &query = QString()) const
QString	hostName() const
bool	isOpen() const
bool	isOpenError() const
bool	isValid() const
QSqlError	lastError() const
QSql::NumericalPrecisionPolicy	numericalPrecisionPolicy() const
bool	open()
bool	open(const QString &user, const QString &password)
QString	password() const
int	port() const
QSqlIndex	primaryIndex(const QString &tablename) const
QSqlRecord	record(const QString &tablename) const
bool	rollback()
void	setConnectOptions(const QString &options = QString())
void	setDatabaseName(const QString &name)
void	setHostName(const QString &host)
void	setNumericalPrecisionPolicy(QSql::NumericalPrecisionPolicy precisionPolicy)
void	setPassword(const QString &password)
void	setPort(int port)
void	setUserName(const QString &name)
QStringList	tables(QSql::TableType type = QSql::Tables) const
bool	transaction()
QString	userName() const

Static Public Members

QSqlDatabase	addDatabase(const QString &type, const QString &connectionName = QLatin1String(defaultConnection))
QSqlDatabase	addDatabase(QSqlDriver *driver, const QString &connectionName = QLatin1String(defaultConnection))
QSqlDatabase	cloneDatabase(const QSqlDatabase &other, const QString &connectionName)
QSqlDatabase	cloneDatabase(const QString &other, const QString &connectionName)
QStringList	connectionNames()
bool	contains(const QString &connectionName = QLatin1String(defaultConnection))
QSqlDatabase	database(const QString &connectionName = QLatin1String(defaultConnection), bool open = true)
QStringList	drivers()
bool	isDriverAvailable(const QString &name)
void	registerSqlDriver(const QString &name, QSqlDriverCreatorBase *creator)
void	removeDatabase(const QString &connectionName)

Protected Functions

QSqlDatabase(QSqlDriver *driver)

QSqlDatabase(const QString &type)

Detailed Description

The QSqlDatabase class provides an interface for accessing a database through a connection. An instance of QSqlDatabase represents the connection. The connection provides access to the database via one of the supported database drivers, which are derived from QSqlDriver. Alternatively, you can subclass your own database driver from QSqlDriver. See How to Write Your Own Database Driver for more information.

Create a connection (i.e., an instance of QSqlDatabase) by calling one of the static addDatabase() functions, where you specify the driver or type of driver to use (depending on the type of database) and a connection name. A connection is known by its own name, not by the name of the database it connects to. You can have multiple connections to one database. QSqlDatabase also supports the concept of a default connection, which is the unnamed connection. To create the default connection, don't pass the connection name argument when you call addDatabase(). Subsequently, the default connection will be assumed if you call any static member function without specifying the connection name. The following snippet shows how to create and open a default connection to a PostgreSQL database:

Once the QSqlDatabase object has been created, set the connection parameters with setDatabaseName(), setUserName(), setPassword(), setHostName(), setPort(), and setConnectOptions(). Then call open() to activate the physical connection to the database

Qsqldatabase Qpsql Driver Not Loaded