问题描述
我正在开发 PyQT 应用程序并想使用 SQL 数据库.发动机没那么重要.我的系统中安装了一个可以运行的 MySQL(我经常使用它),并且默认情况下在我的 system32 文件夹中存在 SQLite3 DLL,并且我还在 qsqlite dll 旁边放了一个副本.
但是当我打电话
db = QtSql.QSqlDatabase.addDatabase("QSQLITE")
或
db = QtSql.QSqlDatabase.addDatabase("QMYSQL")
我得到的是:
QSqlDatabase:未加载 QSQLITE 驱动程序QSqlDatabase:可用的驱动程序:
根本没有驱动程序.我应该怎么办?提前致谢.
我的英语不太好.
我在 windows 10 下使用 Python 2.7,Postgresql,并在 QT 中开发 gui,使用 PyQt4 和 QtSql.并使用spyder.(实际上一切都包含在 Python ( x , y) 中)
,-) 但这是一个简单的解决方案.打开文件 C:\Python27\qt.conf,首先我在文件里面有这几行:
Prefix = C:/Python27/Lib/site-packages/PyQt4二进制文件 = C:/Python27/Lib/site-packages/PyQt4
然后添加下一行:
Plugins = C:/Python27/Lib/site-packages/PyQt4/plugins翻译 = C:/Python27/Lib/site-packages/PyQt4/translations
确保插件在 C:/Python27/Lib/site-packages/PyQt4/plugins 中.然后关闭python并再次打开.然后所有的工作完美.您在这里找到了相同的答案 http://www.voidynullness.net/blog/2013/01/24/pyqt-database-driver-loading-issues-on-windows-after-installing-pyside/>
I'm developing a PyQT application and want to use a SQL database. The engine doesn't matter that much. And I have a working MySQL installed in my system (I use it frequently), and also the SQLite3 DLL is present, by default in my system32 folder, and I have also put a copy beside qsqlite dll.
But when I call
db = QtSql.QSqlDatabase.addDatabase("QSQLITE")
or
db = QtSql.QSqlDatabase.addDatabase("QMYSQL")
All I get is:
QSqlDatabase: QSQLITE driver not loaded
QSqlDatabase: available drivers:
No Drivers at all. What should I do? Thanks in advance.
I don't speak english very well.
I use Python 2.7 under windows 10, Postgresql, and developt the gui in QT , use PyQt4 and QtSql. And use spyder. (In reality everything is included in Python ( x , y))
,-) but here is the easy solution.Open the file C:\Python27\qt.conf, First I had inside the file this lines:
Prefix = C:/Python27/Lib/site-packages/PyQt4
Binaries = C:/Python27/Lib/site-packages/PyQt4
then you add the next lines:
Plugins = C:/Python27/Lib/site-packages/PyQt4/plugins
Translations = C:/Python27/Lib/site-packages/PyQt4/translations
Make sure that the plugins are in C:/Python27/Lib/site-packages/PyQt4/plugins.Then close python and open again. Then all workperfectly. You found the same answer here http://www.voidynullness.net/blog/2013/01/24/pyqt-database-driver-loading-issues-on-windows-after-installing-pyside/
这篇关于PyQT 找不到任何 SQL 驱动程序的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!