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:
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/)
Start with ODBC and then move on to FreeTDS.
./configure --prefix=/home/joe/software/freetds -sysconfdir=/etc --disable-gui make make install