Skip to content
  • 0 Votes
    2 Posts
    3k Views
    Kanni1303K

    My ini file content
    cat ~/.odbc.ini
    [MSSQL]
    Driver = FreeTDS
    Description = Northwind sample database
    Trace = No
    Server = 122.165.14.207
    Port = 1433
    Database = JSEB_SBM
    cat /usr/local/etc/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
    [MSSQL]
    host = 122.165.14.207
    port = 1433
    tds version = 7.1
    and my Qt call
    QSqlDatabase db = QSqlDatabase::addDatabase("QODBC3");
    db.setDatabaseName("MSSQL");
    db.setUserName("sa");
    db.setPassword("*******");
    db.setHostName("122.165.14..207");
    db.setPort(1433);