Unable to connect to mssql server from qt application in ubuntu

[Alexmqueee]

Hello everyone!

Unable to connect to mssql server from qt application in ubuntu 20.04
Sql server located in windows 7
The connection is definitely present, because it was possible to connect through DDbeaver.

Can anyone help me in this situation?

Code:

    QSqlDatabase db = QSqlDatabase::addDatabase("QODBC3");


    db.setConnectOptions();
    QString serverName = "566***";
    QString ipName = "tcp:192.168.144.101,1433";
    QString dbName = "St***";
    QString connectionString =  QString("DRIVER={ODBC Driver 18 for SQL Server};Server=%1;Database=%2;").arg(ipName).arg(dbName);

    db.setDatabaseName(connectionString);
    db.setUserName("sa");
    db.setPassword("top123TOP");
    if (db.open())
    {
        qDebug() << "Correct connection";
    }
    else
    {
        QString error = db.lastError().text();
        qDebug() << error;
    }

otuput is:

"[Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: Error code 0x2746 [Microsoft][ODBC Driver 18 for SQL Server]Client unable to establish connection QODBC3: Unable to connect"

odbcinst.ini

[ODBC Driver 18 for SQL Server]
Description=Microsoft ODBC Driver 18 for SQL Server
Driver=/opt/microsoft/msodbcsql18/lib64/libmsodbcsql-18.0.so.1.1

[Christian Ehrlicher]

You should check your connection string e.g. on the command line to see if it's correct.

[Alexmqueee]

similar answer, not sure if the problem is only with the connection string

./sqlcmd -d StandLD -S 192.168.144.101,1433 -U sa -P top123TOP 
Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : TCP Provider: Error code 0x2746.
Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : Client unable to establish connection.

[ChrisW67]

@Alexmqueee said in Unable to connect to mssql server from qt application in ubuntu:

ODBC Driver 18 for SQL Server]TCP Provider: Error code 0x2746

No firewall on the SQL Server?
TCP enabled on the SQL Server?
Is the server expecting SSL/TLS and do you have that support on the client side?

[Alexmqueee]

the following solution helped

This was helpful.

Ubuntu 20.04 PHP 7.4 using the 19.10 drivers for sqlsrv

We have a real old SQL server out there . The SQL Server show's version 10.50.2550.0, i think it's SQL Server 2008 R2. I had to use TLSv1 to connect to the server. I also had to do a "systemctl restart apache2" to get it to take affect. TLSv1.1 did not work with my MSSQL server version.

Error message: Connection failed: SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol]Database Connection Error

edit: /etc/ssl/openssl.cnf
1st line in the file added
openssl_conf = default_conf

End of file added

[default_conf]
ssl_conf = ssl_sect

[ssl_sect]
system_default = system_default_sect

[system_default_sect]
MinProtocol = TLSv1
CipherString = DEFAULT@SECLEVEL=1
Not 100% sure why i had to restart apache2 for it to take effect, but I had to.

systemctl restart apache2
reloaded the page and it works

from:https://github.com/microsoft/msphpsql/issues/1112

[Christian Ehrlicher]

Then please mark this topic as solved, thx.