Re: FreeTDS - PHP - Mac OS X Leopard Server

On Sep 25, 2009, at 14:59, Nikhil wrote:

> Does anyone have a successful FreeTDS installation with Leopard  
> Server? The built-in PHP module in Leopard is not configured for  
> MSSQL and I cannot seem to get PHP to talk with FreeTDS.

You'll have to build and install the mssql php extension.

First you have to get the PHP source code matching the version on your  
system.
It's probably easiest to go to
http://www.opensource.apple.com/

Select the Mac OS X version you got, and look for the package named  
"apache_mod_php-*"

Expand the archive until you get to the actual PHP source code, then  
it should be as simple as:

cd ext/mssql
phpize && ./configure && make && sudo make install

Then edit /etc/php.ini to get your freshly installed extension loaded:
extension = mssql.so

Finally you may have to reload Apache so that the changes could take  
place.
sudo apachectl graceful


Or you could try to use the ODBC driver in FreeTDS as PHP on Mac OS X  
already comes with the odbc extension built in.