16,235
社区成员
发帖
与我相关
我的任务
分享
db = QSqlDatabase::database(SqlExpressway);
if ( db.isValid() == false )
{
db = QSqlDatabase::addDatabase("QODBC", SqlExpressway);
QString dsn = QString("DRIVER={SQL SERVER};SERVER=%1;port=%2;DATABASE=%3;uid=%4;pwd=%5;")
.arg("192.168.1.214")
.arg(1344)
.arg("expressway")
.arg("sa")
.arg("");
db.setDatabaseName(dsn);
db.setHostName("192.168.1.214");
db.setPort(1344);
db.setUserName("sa");
db.setPassword("");
if ( db.open() == false )
{
db.removeDatabase(SqlExpressway);
qDebug()<<"error:"<<db.lastError().text();
}
}
qDebug() << "Available drivers:";
QStringList drivers = QSqlDatabase::drivers();
foreach(QString driver, drivers)
qDebug() << "\t" << driver;
error:"Driver not loaded Driver not loaded"
执行语句:select * from audit; 数据库:123 错误代码[FreeTDS][SQL Server]Read from the server failed QODBC3: Unable t
[/quote]我也遇到了你一样的问题,已经用QODBC连上了SQL Server,可以insert ,但是不能select 。请问你是怎么解决的呢?
执行语句:select * from audit; 数据库:123 错误代码[FreeTDS][SQL Server]Read from the server failed QODBC3: Unable t