Problem with connection to MS SQL on Linux

[kprzeb]

Hello,
I have Problem with connection to MS SQL on Linux
My code looks like this:

QSqlDatabase m_db;
 
    m_db = QSqlDatabase::addDatabase("QODBC3");
    m_db.setDatabaseName("DRIVER={ms};SERVER=192.168.7.23;TDS_VERSION=8.0;PORT=1433;DATABASE=Hamownia;UID=admin;PWD=haslo;");
 
    qDebug() << "polaczono" << m_db.open();
    qDebug() << "DRIVERS :" << QSqlDatabase::drivers();
    qDebug() << "error" << m_db.lastError();
 
    if(!m_db.open()){
        qDebug()<<"ERROR: "<<QSqlError(m_db.lastError()).text();
    } else {
        qDebug()<<"Ok";
    }

QSqlDatabase m_db;

    m_db = QSqlDatabase::addDatabase("QODBC3");
    m_db.setDatabaseName("DRIVER={ms};SERVER=192.168.7.23;TDS_VERSION=8.0;PORT=1433;DATABASE=Hamownia;UID=admin;PWD=haslo;");

    qDebug() << "polaczono" << m_db.open();
    qDebug() << "DRIVERS :" << QSqlDatabase::drivers();
    qDebug() << "error" << m_db.lastError();

    if(!m_db.open()){
        qDebug()<<"ERROR: "<<QSqlError(m_db.lastError()).text();
    } else {
        qDebug()<<"Ok";
    }

To copy to clipboard, switch view to plain text mode 

Program replay:

root@raspberrypi:/home/pi/kompilacje/qt/sql_console# ./sql_console
polaczono false
DRIVERS : ("QMYSQL3", "QMYSQL", "QODBC3", "QODBC")
error QSqlError(0, "QODBC3: Unable to connect", "[unixODBC][Driver Manager]Data source name not found, and no default driver specified")
ERROR:  "[unixODBC][Driver Manager]Data source name not found, and no default driver specified QODBC3: Unable to connect"

root@raspberrypi:/home/pi/kompilacje/qt/sql_console# ./sql_console
polaczono false
DRIVERS : ("QMYSQL3", "QMYSQL", "QODBC3", "QODBC")
error QSqlError(0, "QODBC3: Unable to connect", "[unixODBC][Driver Manager]Data source name not found, and no default driver specified")
ERROR:  "[unixODBC][Driver Manager]Data source name not found, and no default driver specified QODBC3: Unable to connect"

To copy to clipboard, switch view to plain text mode 

isql connect without any problems:

root@raspberrypi:/home/pi/kompilacje/qt/sql_console# isql -v ms admin haslo
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> quit

root@raspberrypi:/home/pi/kompilacje/qt/sql_console# isql -v ms admin haslo
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> quit

To copy to clipboard, switch view to plain text mode 

And this is my config file :

cat /etc/odbc.ini
[MS]
 
Description        = Coeenxion para microsoft sql server
Driver          = ms-sql
Servername      = ms-sql
UID =           admin
Port    =               1433
 
cat /etc/odbcinst.ini
 
[ms-sql]
Description             =  Conexiona microsoft sql server
Driver          = /usr/lib/arm-linux-gnueabihf/odbc/libtdsodbc.so
Setup           = /usr/lib/arm-linux-gnueabihf/odbc/libtdsS.so
UsageCount      = 1
FileUsage       = 1
 
root@raspberrypi:/home/pi/kompilacje/qt/sql_console# cat /etc/freetds/freetds.conf
#   $Id: freetds.conf,v 1.12 2007/12/25 06:02:36 jklowden Exp $
#
# This file is installed by FreeTDS if no file by the same
# name is found in the installation directory.
#
# For information about the layout of this file and its settings,
# see the freetds.conf manpage "man freetds.conf".
 
# Global settings are overridden by those in a database
# server specific section
[global]
        # TDS protocol version
;       tds version = 4.2
 
        # Whether to write a TDSDUMP file for diagnostic purposes
        # (setting this to /tmp is insecure on a multi-user system)
;       dump file = /tmp/freetds.log
;       debug flags = 0xffff
 
        # Command and connection timeouts
;       timeout = 10
;       connect timeout = 10
 
        # If you get out-of-memory errors, it may mean that your client
        # is trying to allocate a huge buffer for a TEXT field.
        # Try setting 'text size' to a more reasonable limit
        text size = 64512
 
# A typical Sybase server
[egServer50]
        host = symachine.domain.com
        port = 5000
        tds version = 5.0
 
# A typical Microsoft server
[egServer70]
        host = ntmachine.domain.com
        port = 1433
        tds version = 7.0
 
[ms-sql]
     # Version 8.0 para SQL Server 2000
     # Version 7.0 para SQL Server 7
     # Version 6.0 para SQL Server 6
     host = 192.168.7.23
     port = 1433
     tds version = 8.0

cat /etc/odbc.ini
[MS]

Description        = Coeenxion para microsoft sql server
Driver          = ms-sql
Servername      = ms-sql
UID =           admin
Port    =               1433

cat /etc/odbcinst.ini

[ms-sql]
Description             =  Conexiona microsoft sql server
Driver          = /usr/lib/arm-linux-gnueabihf/odbc/libtdsodbc.so
Setup           = /usr/lib/arm-linux-gnueabihf/odbc/libtdsS.so
UsageCount      = 1
FileUsage       = 1

root@raspberrypi:/home/pi/kompilacje/qt/sql_console# cat /etc/freetds/freetds.conf
#   $Id: freetds.conf,v 1.12 2007/12/25 06:02:36 jklowden Exp $
#
# This file is installed by FreeTDS if no file by the same
# name is found in the installation directory.
#
# For information about the layout of this file and its settings,
# see the freetds.conf manpage "man freetds.conf".

# Global settings are overridden by those in a database
# server specific section
[global]
        # TDS protocol version
;       tds version = 4.2

        # Whether to write a TDSDUMP file for diagnostic purposes
        # (setting this to /tmp is insecure on a multi-user system)
;       dump file = /tmp/freetds.log
;       debug flags = 0xffff

        # Command and connection timeouts
;       timeout = 10
;       connect timeout = 10

        # If you get out-of-memory errors, it may mean that your client
        # is trying to allocate a huge buffer for a TEXT field.
        # Try setting 'text size' to a more reasonable limit
        text size = 64512

# A typical Sybase server
[egServer50]
        host = symachine.domain.com
        port = 5000
        tds version = 5.0

# A typical Microsoft server
[egServer70]
        host = ntmachine.domain.com
        port = 1433
        tds version = 7.0

[ms-sql]
     # Version 8.0 para SQL Server 2000
     # Version 7.0 para SQL Server 7
     # Version 6.0 para SQL Server 6
     host = 192.168.7.23
     port = 1433
     tds version = 8.0

To copy to clipboard, switch view to plain text mode 

Do you have any ideas
Thanks

[d_stranz]

Are your SQL plugins located in the right place with respect to your app? See this.

[ChrisW67]

Try calling setDatabaseName with the DSN you have configured (and the one you used with isql),

M_db.setDatabaseName("ms"); // also try "MS"
M_db.setUserName("foo");
M_db.setPassword("bar");

M_db.setDatabaseName("ms"); // also try "MS"
M_db.setUserName("foo");
M_db.setPassword("bar");

To copy to clipboard, switch view to plain text mode