Qt连接OBDC数据库连接失败

Question

Qt初学，最近在学习数据库相关。
程序的输出结果是数据库创建失败（如下），不知道是哪里出了问题，求大神指教
贴上源代码：
#ifndef CONNECTION
#define CONNECTION
#include
#include
#include

static bool createConnection()
{
QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
db.setDatabaseName("DRIVER={Microsoft Access Driver (*.accdb)};FIL={MS Access};DBQ=Database1.accdb");
if(!db.open())
{
QMessageBox::critical(0,"Cannot open database","Unable to establish a database connection.",QMessageBox::Cancel);
return false;
}
QSqlQuery query;
query.exec("Create table record(id int primary key,""RecordName varchar[20])");
query.exec("insert into record values(0,Had a good meal)");
query.exec("insert into record values(1,Bought clothes)");
return true;
}

#endif // CONNECTION

Answer 1

Create table record(id int primary key,RecordName varchar[20]));这个不需要双引号，insert into 中的字符串参数需要加单引号