OS X - PHP 4.3 & 5.0 - FreeTDS - MSSQL 7.0

06 May 2005

I have been using a package from http://www.entropy.ch/software/macosx/php/ to get an up to date version of PHP for OS X Server. I really like the package and it's options work great and do an excellent job of keeping up to date as well as making sure they do not break the default Apple settings.
I have recently had to use MSSQL 7.0 database to connect to some legacy data. I use ADODB to extract the SQL layer so I could change the database connections one it was all ported. Here is the only thing I had to add to get it to connect.

I have learned that in order to get ADODB to connect to MSSQL server (v7.0) you have to modify /usr/local/php/etc/freetds.conf (/usr/local/php5/etc/freetds.conf) by adding an entree such as this.

        host = sql.example.com
        port = 1433
        tds version = 7.0

The host has to match the entree for ADODB to pick it up. This works for both 4.3.x and 5.0.x.

Just thought I would share with the online community.

BTW: Many thanks for Marc for including FreeTDS. You have made our server migrations from various platforms to OS X so much easier.

{"display_name"=>"chris", "login"=>"chris", "email"=>"crmacd@gmail.com", "url"=>"http://www.crmacd.com"}