QODBC by QT

[mirek_zaklosa]

Hello,

I've a connection string to ODBC:

Provider=ASAProv.90;Persist Security Info=True;User ID=DBA;Data Source=OCONET

Provider=ASAProv.90;Persist Security Info=True;User ID=DBA;Data Source=OCONET

To copy to clipboard, switch view to plain text mode 

I'm trying to use it by:

QSqlDatabase db;
    db = QSqlDatabase::addDatabase("QODBC"); 
    QString connectString = "Provider=ASAProv.90;Persist Security Info=True;User ID=DBA;Data Source=OCONET;";
    db.setDatabaseName(connectString);
    if(db.open())
    {
        QMessageBox::about(this,"Connected","Connected");
    }else{
        QMessageBox::about(this,"NOT Connected","NOT Connected");
    }

QSqlDatabase db;
    db = QSqlDatabase::addDatabase("QODBC"); 
    QString connectString = "Provider=ASAProv.90;Persist Security Info=True;User ID=DBA;Data Source=OCONET;";
    db.setDatabaseName(connectString);
    if(db.open())
    {
        QMessageBox::about(this,"Connected","Connected");
    }else{
        QMessageBox::about(this,"NOT Connected","NOT Connected");
    }

To copy to clipboard, switch view to plain text mode 

and I've got "NOT Connected"
What I'm doing wrong?

[Lesiok]

If db not open look at QSqlDatabase::lastError.

[mirek_zaklosa]

I've got:

Driver not loaded

[mirek_zaklosa]

I've found in Windows 7 "ODBC Configuration":3.png

with "MyDRIVER". Test connection display "connection ok".

Now I'm trying connect by using "MyDRIVER":

QSqlDatabase db;
    db = QSqlDatabase::addDatabase("QODBC");
    QString connectString = "DRIVER={MyDRIVER}";
    db.setDatabaseName(connectString);
    if(db.open())
    {
        QMessageBox::about(this,"Connected","Connected");
    }else{
        QMessageBox::about(this,"NOT Connected","NOT Connected");
        QMessageBox::about(this,"NOT Connected",db.lastError().databaseText());
    }

QSqlDatabase db;
    db = QSqlDatabase::addDatabase("QODBC");
    QString connectString = "DRIVER={MyDRIVER}";
    db.setDatabaseName(connectString);
    if(db.open())
    {
        QMessageBox::about(this,"Connected","Connected");
    }else{
        QMessageBox::about(this,"NOT Connected","NOT Connected");
        QMessageBox::about(this,"NOT Connected",db.lastError().databaseText());
    }

To copy to clipboard, switch view to plain text mode 

And i've got:
"NOT Connected"
"Driver not loaded"

[anda_skoa]

"Driver not loaded" could mean that the QSql Plugin for QODBC is not present or fails to load.

You should be able to get more information by setting the QT_DEBUG_PLUGINS variable, see https://doc.qt.io/qt-5/deployment-pl...ugging-plugins

Cheers,
_