Skip to content
QtWS25 Last Chance
  • Qt unixODBC and FreeTDS

    General and Desktop odbc unixodbc freetds mssql sql
    2
    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);