Hi, i have problem with MS SQL, after i open connection without error, all query i exec have size -1
void MainWindow::on_pushButtonLogin_clicked()
{
QString nameServer
= "192.168.3.201\\OPTIMA";
QString dataBaseName
= QString("DRIVER={SQL Server};SERVER=%1;DATABASE=%2;").
arg(nameServer
).
arg(dbName
);
db.setDatabaseName(dataBaseName);
db.setUserName("<LOGIN>");
db.setPassword("<PASSWORD>");
if (!db.open())
}
void MainWindow::on_pushButtonGetUsers_clicked()
{
query.exec("SELECT * FROM [CDN].[Kontrahenci]");
QMessageBox::critical(0,
QObject::tr("Database Error"), query.
lastError().
text() );
//No error
}
void MainWindow::on_pushButtonLogin_clicked()
{
QString nameServer = "192.168.3.201\\OPTIMA";
QString dbName = "CDN_Test";
QString dataBaseName = QString("DRIVER={SQL Server};SERVER=%1;DATABASE=%2;").arg(nameServer).arg(dbName);
db = QSqlDatabase::addDatabase("QODBC");
db.setDatabaseName(dataBaseName);
db.setUserName("<LOGIN>");
db.setPassword("<PASSWORD>");
if (!db.open())
QMessageBox::critical(0, QObject::tr("Database Error"), db.lastError().text());
}
void MainWindow::on_pushButtonGetUsers_clicked()
{
QSqlQuery query(db);
query.exec("SELECT * FROM [CDN].[Kontrahenci]");
QMessageBox::critical(0, QObject::tr("Database Error"), query.lastError().text() ); //No error
QMessageBox::critical(0, QObject::tr("Database Error"), QString::number( query.size() )); // -1
}
To copy to clipboard, switch view to plain text mode
Bookmarks