QT连接SQLSERVER

#include <QCoreApplication>
#include <QtSql>
#include <QtDebug>

int main(int argc, char *argv[])
{
    QCoreApplication a(argc, argv);
    QString servername="THINKPAD-PC"; //LOCALHOST
    QString dbname="AdventureWorks2008R2";

    QSqlDatabase db=QSqlDatabase::addDatabase("QODBC");

    db.setConnectOptions();
    QString dsn=QString("DRIVER={SQL SERVER};SERVER=%1;DATABASE=%2;Trusted_Connection=Yes;").arg(servername).arg(dbname);

    db.setDatabaseName(dsn);
    if(db.open())
    {
        qDebug()<<"opened";



        db.close();

    }
    else
    {
        qDebug()<<"ERROR="<<db.lastError().text();

    }



    return a.exec();
}

 

posted @ 2015-02-28 17:43  HNU-王田  阅读(1989)  评论(0编辑  收藏  举报