PHP 5.3.6 + MSSQL + FreeTDS

To go against what the community will tell you it is possible to compile MSSQL module in PHP 5.3.x (dont know why you would want to thought!)

I’ve used the FreeTDS module and manually enabled the MSSQL module in the php.ini file and presto, MSSQL support on linux with PHP 5.3.6!

I’m not going to go into large detail, if you can’t understand what I have written below than you’re going to have a hard time installing this. I could go into more detail however at this point in time I do not have the time to do so. So if someone out there wants to take what I have written and expand on it I’d be happy to re-post it.

cd /
mkdir /source
cd /source

wget ftp://ftp.ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgz

tar -xv freetds-stable.tgz
cd freetds-0.91

./configure –enable-msdblib –prefix=/usr/local/freetds
make && make install

cp include/tds.h /usr/local/freetds/include
cp src/tds/.libs/libtds.a /usr/local/freetds/lib

cd /source

wget http://au.php.net/get/php-5.3.6.tar.bz2/from/this/mirror -o php-5.3.6.tar.bz2
tar -xf php-5.3.6.tar.bz2
cd php-5.3.6

cd etx/mssql
phpize
./configure –with-mssql=/usr/local/freetds
make

Find out where PHP expects to find extension libraries. The simplest way to check this is through the command line.

php -i | grep extension_dir

Example: /usr/lib/php5/20090626

cp modules/mssql.so /usr/lib/php5/20090626

Edit php.ini file and add:

extension=mssql.so

/etc/init.d/apache2 restart

 

Done, enjoy!

Another good tutorial to use is: http://webscholar.net/2008/02/19/php-mssql-freetds/

Comments are closed.