Configure FreeTDS+Apache+PHP+MSSQL 2000 di *nix
Configure Freetds
1. Download Freetds 0.53 at www.freetds.org
2. ./configure –prefix=/usr/local/freetds –with-tdsver=7.0
3. make
4. make install
5. Edit /usr/local/freetds/etc/freetds.conf
6. Add
[MyServer70] ¡¥DSN for PHP
host = 10.23.52.114 ¡¥MS SQL Server IP
port = 1433 ¡¥MS SQL Default Port
tds version = 7.0 ¡¥MS SQL 2000 Version No.
client charset = UTF-8 ¡¥Charset Encoding, it can be omitted if you don’t want to disply in unicode
Configure PHP 4.12
1. Download PHP4 from www.php.net
2. ./configure –with-sybase=/usr/local/freetds –with-apache=../{Apache Path} –enable-track-vars
3. copy all files in /usr/local/freetds/lib/ to /usr/lib
4. make
5. make install
Configure Apache 1.3.24
1. ./configure –activate-module=src/modules/php4/libphp4.a
2. make
3. make install
4. cp php.ini-dist /usr/local/lib/php.ini
5. Edit Your httpd.conf or srm.conf file and add;
AddType application/x-httpd-php .php
6. /usr/local/apache/bin/apachectl start
Feel free to email to us @ aikok@netfront.net or elee@kinwai.net
German Chu & Eagle Lee
