validate database connection

[hoshy]

Hi folks,

how can I validate a database connection if the connection has been established correct.

My problem is... if I set a wrong DatabaseName with setUserName and open the connection with the wrong DatabaseName I get:

isOpen = true
isOpenError = false
isValid = true

how can that be????

thx

[spirit]

what does this code return?

...
QSqlDatabase db = QSqlDatabase::addDatabase(...);
if (!db.open()) {
    qDebug() << db.lastError().text();
    return;
}
...

...
QSqlDatabase db = QSqlDatabase::addDatabase(...);
if (!db.open()) {
    qDebug() << db.lastError().text();
    return;
}
...

To copy to clipboard, switch view to plain text mode 

[hoshy]

Ahh I found the problem...

I was testing it with an empty String, and when I do so the result by calling:

if (!db.open())
    qDebug() << db.lastError().text();

if (!db.open())
    qDebug() << db.lastError().text();

To copy to clipboard, switch view to plain text mode 

...is nothing, because QT opens the connection without any errors. But when I use a wrong String, I get the errortext...

thx