QSqlDatabase problem. Is ever valid

Xeyos

Hi,
I have a problem in using QSqlDatabase.
If all the parameters are correct the connection is fine, but if I put a host that does not exist:
db.open () returns true;
db.isValid () returns true;
How can I check then the host?

mcosta

Hi and welcome to devnet,

could you post an example of that problem??

Xeyos

My connection:
db = QSqlDatabase::addDatabase(driver);
db.setHostName(ui->_input_host->text());
db.setUserName(ui->_input_user->text());
db.setPassword(ui->_input_password->text());
db.setPort(ui->_input_port->text().toInt());

By inserting some hosts unavailable db.open () return true.
I would first check if the host exists.
you can also return the error on the user that connects?

mcosta

Hi,

what the driver are you using??

is your code like this??

void MyClass::connectToDb() {
    QSqlDatabase db = QSqlDatabase::addDatabase(driver);
    db.setHostName(ui->_input_host->text());
    db.setUserName(ui->_input_user->text());
    db.setPassword(ui->_input_password->text());
    db.setPort(ui->_input_port->text().toInt());

    if (db.open()) {
    // open
    } else {
    // error
    }
}

or QSqlDatabase::open() is called in different way?

Xeyos

The user can choose the driver:
In my case with QPSQL everything works properly and if you choose such QSQLITE connection occurs even though the driver is wrong.

It is like the code you wrote:
bool ok = db.open;
if (ok) {
...
} else {
...
}

mcosta

Hi,

QSQLITE uses only databaseName (a sqlite database is a file in the current file system or is an in memory database if the name is :memory:).

Read here to find the differences between drivers and how to set connenction parameters