QT用ODBC连接SQL Server

leibniz_zsu

1. db=QSqlDatabase::addDatabase("QODBC", "db");
   
2. db.setHostName("localhost");
   
3. db.setPort(1433);
   
4. db.setDatabaseName("ODBC数据源名");
   
5. db.setUserName("sa");
   
6. db.setPassword("password");
   
7. if(!db.open())
   
8. {
   
9. QMessageBox::information(this, tr("db"), tr("can not open"));
   
10. return false;
    
11. }

关键是要把QT文件夹下的plugins下的sqldrivers文件夹拷贝到编译好的可执行文件相同的目录下。

1. #ifndef CONNECTION_H
   
2. #define CONNECTION_H
   
3. #include <QMessageBox>
   
4. #include <QSqlDatabase>
   
5. #include <QSqlError>
   
6. #include <QSqlQuery>
   
7. 
   
8. 
   
9. static bool connection()
   
10. {
    
11.     QSqlDatabase db=QSqlDatabase::addDatabase("QODBC");
    
12.     db.setDatabaseName(QString("DRIVER={SQL SERVER};"
    
13.                                "SERVER=%1;" //服务器名称
    
14.                                "DATABASE=%2;"//数据库名
    
15.                                "UID=%3;" //登录名
    
16.                                "PWD=%4;" //密码
    
17.                                ).arg("TANY_PC")
    
18.                                 .arg("MyData")
    
19.                                 .arg("sa")
    
20.                                 .arg("")
    
21.                        );
    
22.     if (!db.open())
    
23.     {
    
24.         QMessageBox::critical(0, qApp->tr("Cannot open database"),
    
25.             db.lastError().databaseText(), QMessageBox::Cancel);
    
26.         return false;
    
27.     }
    
28.     else
    
29.     {
    
30.         QMessageBox::information(0,"Connect Database","connect success!",QMessageBox::Ok);
    
31.         return true;
    
32.     }
    
33.     return true;
    
34. }
    
35. #endif // CONNECTION_H