Qt5.7 连接Access数据库,open时总失败!为什么?
MainWindow::MainWindow(QWidget *parent) :
QMainWindow(parent),
ui(new Ui::MainWindow)
{
ui->setupUi(this);
QStringList strList = QSqlDatabase::drivers();
foreach(QString str,strList)
qDebug()<<"\t"<<str;
/*此处输出:
* "QSQLITE"
* "QMYSQL"
* "QMYSQL3"
* "QODBC"
* "QODBC3"
* "QPSQL"
* "QPSQL7"
*/
db = QSqlDatabase::addDatabase("QODBC");
qDebug()<<"装载ODBC Driver 成功?"<<db.isValid();
QString dsn = "DRIVER={Microsoft Access Driver (*.mdb,*.accdb)};FIL={MS Access};DBQ=E:\\Database2.mdb";
db.setDatabaseName(dsn);
bool isOK = db.open();
qDebug()<<isOK; //isOk永远是false 为什么?
if(!isOK)
{
QMessageBox::critical(0,tr("打开数据库错误"),tr("不能建立数据库连接\n"),QMessageBox::Cancel);
}