How to make FreeTDS, unixODBC and QT working together

UnixODBC and FreeTDS driver compialtion and configuration has been taken from the

Here are instructions for getting tsql and isql to play nice together.
Apt-getting doesn’t always get you all the tools you need to develop against SQLserver and Sybase.
Gather some important packages:

apt-get install libtool bison autotools-dev g++ build-essential tcsh unixodbc-dev tdsodbc

Download, extract and compile FreeTDS driver:

tar xzvf freetds-stable.tgz
cd freetds-0.82/
./configure --prefix=/usr --sysconfdir=/etc --with-unixodbc=/usr --with-tdsver=8.0
 make && make install clean

Create a file named tds.driver.template with the following contents:

Description     = v0.82 with protocol v8.0
Driver          = /usr/lib/

Register the driver with ODBC

odbcinst -i -d -f tds.driver.template

On 64 bit Debian, I’ve run into the situation where freetds won’t compile against the distribution’s ODBC. To resolve this, it was necessary to compile and install a parallel ODBC and compile freetds against it.
If this is a server, you may not have a GUI, so don’t try to compile with it.

tar xvf unixODBC-2.2.14.tar
cd unixODBC-2.2.14
./configure --enable-gui=no
make install

Default installation dir is: /usr/local/bin/. Now, follow the above instructions replacing the configure line for freetds with this:

./configure --prefix=/usr --sysconfdir=/etc --with-unixodbc=/usr/local --with-tdsver=8.0

Possible errors:

  • SQLInstallDriverEx failed with Invalid install path
  • . Probably /usr/local/etc/odbcinst.ini file is missing, or use root account to install driver template.

How to test unixODBC:

odbcinst -s -q show available ODBC sources
odbcinst -d -q show available ODBC drivers
odbcinst -j show config
isql -v datasourcename login password conenct using data source name

How to test freetds:

tsql -H -p 1433 -U sa -P password conenct using host name
tsql -S datasourcename -U sa -P password conenct using data source name from the freetds.conf file

Configure QT to work with unixODBC

Note that QT application will use files:

, but isql uses:

The best solution is to create symbolic links and keep orginal files in one place.

cd $QT/src/plugins/sqldrivers/odbc
qmake "INCLUDEPATH+=/usr/local/unixODBC/include" "LIBS+=-L/usr/local/unixODBC/lib -lodbc"
make install

On Ubuntu x64 we need to modify following files manually:
sudo vim /usr/local/include/sqltypes.h

#ifdef ODBCINT64
//typedef ODBCINT64     SQLBIGINT;
typedef long    SQLBIGINT;
#ifdef UODBCINT64
typedef unsigned long   SQLUBIGINT;

vim ../../../sql/drivers/odbc/qsql_odbc.cpp

when connection fails, then try to update add LD_LIBRARY_PATH in Qt project settings
LD_LIBRARY_PATH = /usr/lib:/usr/lib/odbc:/usr/local/lib:/usr/local/Trolltech/Qt-4.7.4/lib

cd $QT/src/plugins/sqldrivers/tds
qmake "INCLUDEPATH+=$QT/QtSources/4.8.1/include" "LIBS+=-L/usr/local/unixODBC/lib -lodbc"
make install
qDebug() << QSqlDatabase::drivers();


QSqlDatabase db = QSqlDatabase::addDatabase("QODBC3");
if( ! )
	qDebug() << "Connection errror:"  << db.lastError().text();
	QSqlQuery query("SELECT country FROM artist", db);
	while (
		QString country = query.value(0).toString();
		qDebug() << country;

#Driver = /usr/lib/
Driver = FreeTDSDriver
Description = Northwind sample database
Trace = Yes
Server =
Port = 4101
Database = kplus
UID = kplus

cat /etc/odbcinst.ini
Description = v0.82 with protocol v8.0
Driver = /usr/lib/
UsageCount = 2
CPTimeout =
CPReuse =

host =
port = 4101
tds version = 5.0
dump file = /var/log/freetds.log



3 thoughts on “How to make FreeTDS, unixODBC and QT working together

  1. Pingback: sql server perl dbi odbc freetds on linux | Back of a Stamp

  2. Pingback: I need to install free TDS ODBC driver in for mssql in RHEL5.3 | VRDITSERVICES

  3. I tried the same but, Qt was not able to find the ini files,
    isql and tsql is working fine for me, no problem with those. but Qt says
    “QSqlError(0, “QODBC3: Unable to connect”, ” [unixODBC][Driver Manager]Data source name not found, and no default driver specified”)”

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s