i can't connect to Azure database in QT

Question

My database is on an Azure server. And I'm trying to connect to it via an ODBC driver (by the way, I tried to install it manually, but I couldn't get it. They say it's built in). I get the following error: "Data source not found and no default ODBC driver specified: Unable to connect"

dataBaseKnowFood = QSqlDatabase::addDatabase("QODBC");
QString connectString = QStringLiteral("myconnectionstring");
dataBaseKnowFood.setDatabaseName(connectString);
dataBaseKnowFood.setPassword("dgf");
dataBaseKnowFood.setUserName("gidgfsg");
if (!dataBaseKnowFood.open())
{
    QMessageBox::critical(this, "Programm", dataBaseKnowFood.lastError().text());
}

Can you post your connection string? I would assume the error to be there. — SebDieBln, Dec 04 '21 at 14:49
`No default ODBC driver specified` cannot make us to blame Qt. https://stackoverflow.com/questions/849887/specify-a-default-driver-for-odbc — Alexander V, Dec 04 '21 at 16:32

score 0 · Answer 1 · answered Dec 04 '21 at 22:13

0

Problem solved. It was required to update this driver and indicate the version of the updated driver in the connection string.

answered Dec 04 '21 at 22:13

Анатолий Чехов

3
3

i can't connect to Azure database in QT

1 Answers1