DanBrother的部落格

# install freetds
cd freetds-0.91
./configure --prefix=/usr/local/freetds \
--enable-msdblib

make && make install

# Re-configure PHP with MSSQL Module
cd /source/php-5.4.0
./configure --prefix=/usr/local/etc/php \
--with-apxs2=/usr/local/apache/bin/apxs \
--with-oci8=/u01/oracle/db11203 \
--with-mssql=/usr/local/freetds

make && make install

libtool --finish /source/php-5.4.0/libs
chmod 755 /usr/local/apache/modules/libphp5.so

Modify php.ini
>>
extention="/usr/lib/php/modules/mssql.so"

Edit /usr/local/freetds/etc/freetds.conf
>>
[my_mssql_connect]
host =10.0.3.30
port = 1433
tds version = 7.0
client charset = UTF-8


vi test_mssql_connect.php
>>
<?php
$conn = mssql_connect("my_mssql_connect","test_user","test_pwd")
or die("Couldn't connect to MSQL Server. Error: ".mssql_get_last_message());
mssql_select_db("my_db");
$rs = mssql_query("select * from dbo.my_table");
$rs_data = mssql_fetch_row($rs);
echo $rs_data[0];
?>