linux 上 php 连mssql,使用 unixodbc + freetds
安装步骤：
安装unixodbc
yum install unixodbc
yum install unixodbc-devel
安装 freetds
./configure --with-tdsver=8.0 --prefix=/usr/local/freetds --enable-msdblib --with-gnu-ld --enable-shared --enable-static
make
make install
vi /usr/local/freetds/etc/freetds.conf
[ppcserver]
host = 192.168.2.120
port = 1433
tds version = 8.0
client charset = utf-8
测试连接
/usr/local/freetds/bin/tsql -s ppcmssql -u 7230 -p 7230
vi /etc/odbcinst.ini
[freetds]
description     = odbc of freetds for ms sql 2000
driver          = /usr/local/freetds/lib/libtdsodbc.so
setup           = /usr/local/freetds/lib/libtds.so
fileusage       = 1
vi /etc/odbc.ini
[odbc data sources]
ppc= ppc sql server
[ppcmssql]
driver          = freetds
description     = ppc sql server
trace           = no
servername      = ppcserver
database        = 7230
测试连接
isql -v ppcmssql 7230 7230