Install Apache/FreeTDS/PHP on FC1 to connect to MSSQL2000 on W2KS ----------------------------------------------------------------- 01. Install your FC1 system and include httpd and httpd-devel packages, do not install PHP 02. Copy freetds and php sources to /usr/local/src/ 03. cd /usr/local/src/ Install and Configure FreeTDS ----------------------------- (http://www.freetds.org) 04. tar -xzvf freetds-stable.tgz 05. cd freetds-0.62.4 06. ./configure --prefix=/usr/local --with-tdsver=8.0 --enable-dbmfix --enable-msdblib 07. make && make install 08. cd /usr/local/src/ Don't forget to setup your database server in /usr/local/etc/freetds.conf There are samples to follow. Check these settings in particular: try domain login = yes nt domain = MYDOMAIN Install and Configure PHP4 -------------------------- (http://www.php.net) 09. tar -xzvf php-4.3.8.tar.gz 10. cd php-4.3.8 11. ./configure --with-apxs2=/usr/sbin/apxs --with-mssql=/usr/local --with-sybase=/usr/local --with-mysql --enable-track-vars --with-gd --with-zlib-dir 12. make && make install 13. cp php.ini-dist /usr/local/lib/php/php.ini Hack PHP Installation --------------------- 14. vi /usr/local/lib/php/php.ini, look for 'sybase.interface_file' directive, uncomment it and change the value to "/usr/local/interfaces" 15. look for 'mssql.secure_connection = Off' and change it to On Test Setup ---------- 16. vi /etc/httpd/conf/httpd.conf and add these lines: a. AddType application/x-httpd-php .php b. AddType application/x-httpd-php-source .phps 17. service httpd restart 18. Write a test php page, for help: http://us2.php.net/manual/en/ref.mssql.php