Qt4.7.3 ODBC驱动
我在Qt中文网站上下了一个Qt SDK4.7.3,在程序中需要访问sql server 数据库,代码大致如下:VehCommDBconnect::VehCommDBconnect(QObject *parent) :
QObject(parent)
{
QString path=QApplication::applicationDirPath()+"/config.ini";
QSettings *mySetting = new QSettings (path,QSettings ::IniFormat);
userName=mySetting->value("DBConnect/UserName","su").toString();
userPwd=mySetting->value("DBConnect/UserPwd","su").toString();
dbIp=mySetting->value("DBConnect/HostIp","127.0.0.1").toString();
}
bool VehCommDBconnect::connDB(){
QSqlDatabase db = QSqlDatabase::addDatabase("QODBC", "dbTemp");
QString dsn = QString::fromLocal8Bit("DRIVER={SQL SERVER};SERVER=127.0.0.1;DATABASE=TNRentCarShop");
db.setDatabaseName(dsn);
db.setHostName(dbIp);
db.setUserName(userName);
db.setPassword(userPwd);
if(!db.open())
{
// qDebug() << QSqlDatabase::drivers();
qDebug() <<db.isOpenError();
return false;
}
qDebug() <<"Connect DB successful";
return true;
}
在编译时访问不到ODBC驱动,总是出现
QSqlDatabase: QODBC driver not loaded
QSqlDatabase: available drivers: QSQLITE问题,我从网上下的qsqlodbc4.dll文件也拷贝到如下目录D:\QtSDK\Desktop\Qt\4.7.3\mingw\plugins\sqldrivers,为什么一直连接不上SQl server数据库,是Qt4.7.3的库不支持ODBC驱动吗?