先在ODBC中设置dsn,命名为QtTest,测试连接成功后在项目中如下配置: //connect.h #include <QtSql> #include <QtGui> static bool createConnection() { QSqlDatabase dbconn = QSqlDatabase::addDatabase("QODBC"); QString dsn = QString::fromLocal8Bit("QtTest"); dbconn.setDatabaseName(dsn); dbconn.setPort(1433); dbconn.setUserName(QString("sa")); dbconn.setPassword(QString("123456")); bool r = dbconn.open(); if (r) { QSqlQuery query ; query.exec("Insert into [testTab] (ID,Name) values('001','Kobe')"); return true; } else { qDebug() << "connect failure!" << endl; return false; } }