Qt4连接SQL Server

先在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;}}