FreeBSD6,PHP connect ms sql server 2000
Wednesday, 28. March 2007, 13:21:01
i think it is the simplest way to fix it.
first install php5 and php5-extensions
Install with php5-extensions, u must check mssql(default it is uncheck).
Notice install process, u will it will install freetds(google it).
Install ok...you should do
cp /usr/local/etc/freebsd.conf.dist /usr/local/etc/freebsd.conf
chmod +r /usr/local/etc/freebsd.conf
ee freebsd.conf
delete # with [MyServer2k] and its sub item. host changed to sql server's ip.
php code like:
mssql_connect('MyServer2k', $dbuser, $dbpass);
mssql function u find it in php handbook.
and u should add line to MyServer2k,,it will help me to solve chinese word show.
client charset = utf-8.
first install php5 and php5-extensions
Install with php5-extensions, u must check mssql(default it is uncheck).
Notice install process, u will it will install freetds(google it).
Install ok...you should do
cp /usr/local/etc/freebsd.conf.dist /usr/local/etc/freebsd.conf
chmod +r /usr/local/etc/freebsd.conf
ee freebsd.conf
delete # with [MyServer2k] and its sub item. host changed to sql server's ip.
php code like:
mssql_connect('MyServer2k', $dbuser, $dbpass);
mssql function u find it in php handbook.
and u should add line to MyServer2k,,it will help me to solve chinese word show.
client charset = utf-8.





