ODBC/FreeTDS

At the time of writing the version of FreeTDS (0.63) included with Ubuntu (8.04) is not compatable with SQL Server 2005, therefore the newer 0.64 version need to be downloaded and built.

Download the source tars:

• unixODBC >= 2.2.12 (http://www.unixodbc.org/)
• FreeTDS >= 0.64 (http://www.freetds.org/)

Preparation

Decide where you want to install this version of ODBC/FreeTDS.

• For example /home/username/software/odbc
• Create the required folder
• Unpack the downloaded source code in an appropriate place (eg. /home/username/software/)

Build Software

Start with ODBC and then move on to FreeTDS.

ODBC

./configure --prefix=/home/joe/software/freetds -sysconfdir=/etc --disable-gui
make
make install