Configure Static/CGI/PHP-5.4 application with Microsoft SQL Server support

For MS-SQL support, you'll need to build FreeTDS and PHP from source in your home directory, and then configure your Static/CGI/PHP-5.4 application to use your local version of PHP.

Here are the commands you can run to build FreeTDS and PHP 5.4:

mkdir -p ~/{src,tmp,local}
export TMPDIR=~/tmp
cd ~/src
wget 'ftp://ftp.freetds.org/pub/freetds/stable/freetds-stable.tgz'
tar xf freetds-stable.tgz
cd freetds-0.91/
./configure --prefix=$HOME/local
make
make install
cd ~/src
wget http://us3.php.net/distributions/php-5.4.40.tar.bz2
tar jxf php-5.4.40.tar.bz2
cd php-5.4.40
./configure --prefix=$HOME/local --with-pdo-mysql --with-pdo-pgsql=/usr/pgsql-9.1 --enable-bcmath --enable-calendar --with-curl --with-openssl --enable-exif --enable-ftp --enable-mbstring --enable-soap --enable-zip --with-freetype-dir --with-gd --with-gettext --with-gmp --with-iconv --with-jpeg-dir --with-kerberos --with-mhash --with-mysql --with-mysqli --with-pgsql=/usr/pgsql-9.1 --with-png-dir --with-regex --with-xmlrpc --with-xsl --with-zlib-dir --with-config-file-path=$HOME/lib --without-pear --enable-sockets --enable-intl --with-mysql-sock=/var/lib/mysql/mysql.sock --with-mssql=$HOME/local
make
make install

Once that's done, you then configure your app to use your local PHP installation instead of the system PHP installation:

cd ~/webapps/example_app
cp $HOME/local/bin/php-cgi my_php.cgi
echo "
Action php_custom /my_php.cgi
<FilesMatch .php$>
    SetHandler php_custom
</FilesMatch>
">>.htaccess

Hope that helps!