在Linux中訪問MSSQL（PHP版）

Linux——IBM PC SERVER 330, RedHat 6.2，Apache 1.3.20 + PHP 4.0.6
Win2k Server——DELL 4400, SQL SERVER 7.0
任務：公司圖書館的數據庫系統采用MSSQL，WEB服務器我選了LINUX（硬件老?。?，為了給全體職工提供在線圖書查詢，需要在LINUX中增加PHP模塊，訪問MSSQL。
解決過程：
找啊找啊找啊找，找到下面這篇E文，很好，居然一把搞定。
但是，我仔細看了PHP 4.X給的E文MANUAL，發現PHP是有MSSQL數據庫訪問支持的，那就是用它的DBX，如果你成功安裝了下面的Freetds，你可以這樣配置編譯PHP：
./configure --prefix=/usr/local/php --enable-dbx --with-mysql --with-apxs=/usr/local/apache/bin/apxs --with-mssql=/usr/local/freetds --with-sybase=/usr/local/freetds --with-gd
make && make install
呵呵輕松搞定，很愉快哦。不想下載安裝Freetds？只用DBX？？不用我教了吧:)

09-Jul-2001 08:57
Building PHP as a DSO for Apache 1.3.19 in Linux RedHat 6.0 to connect
to
WIN2000 Server running SQL Server 2000
========================================
What Do We Need:
================
* PHP Source 4.0.6
* Apache 1.3.19
* FreeTDS 0.51
* Dual Login Mode in SQL Server Enterprise Manager (Windows ONLY login
will
not work!)
Installation Procedure:
=======================
(1) Build Apache, enable Dynamic Shared Object (DSO)
gzip -dc apache_1.3.19.tar.gz | tar -xf -
cd apache_1.3.19
./configure --prefix=/usr/local/apacheso --enable-module=so
make && make install
(2) Build Freetds
tar -xzvf freetds-0.51.tgz
cd freetds-0.51
./configure --prefix=/usr/local/freetds --with-tdsver=4.2
--enable-dbmfix
make && make install
(3) Link Freetds library
edit /etc/ld.so.conf (or equivalant) add /usr/local/ftds/lib to
it
run ldconfig (located in /sbin/ldconfig in linux)
(4) Build PHP
gzip -dc php-4.0.6.tar.gz | tar -xf -
cd php-4.0.6
edit ext/sybase/config.m4, replace dbopen with dsdbopen
(in version 4.0.6 of PHP this in on line 27 of config.m4)
./configure --with-apxs=/usr/local/apacheso/bin/apxs
--with-mssql=/usr/local/freetds --with-sybase=/usr/local/freetds
--with-mysql --enable-track-vars
make && make install
cp php.ini-dist /usr/local/lib/php.ini (the location of this file
may differ for your installation)
(5) Hack PHP initialization file
edit /usr/local/lib/php.ini file, look for sybase.interface_file
directive
uncomment it and change the value to
"/usr/local/freetds/interfaces" (location where you installed
freeTDS)
(6) Hack freeTDS file
edit /usr/local/ftds/interfaces file, for MSSQL, you have to add
an entry like the following*:
mssqlconnection
query tcp tds4.2 IPADDRESS_OF_SQL_SERVER 1433
*Note: when writing PHP code, use the name
"mssqlconnection" for hostname,
so you would use something like:
$conn = "mssqlconnection";
$username = "myuser";
$password = "mypass";
$dbc = mssql_connect ("$conn",
"$username", "$password");
(7) Setup Apache httpd.conf file and run!
Do a check to see if everything is OK, by starting Apache.
Good LucK!!!
(作者：老頑童)

原文轉自：http://www.kjueaiud.com