必需安装freetds
下载freetds
wget
ftp://ftp.freetds.org/pub/freetds/stable/freetds-stable.tgz
tar zxf freetds-stable.tgz
cd freetds-stable/
/usr/bin/phpzie
./configure --prefix=/usr/local/freetds --with-tdsver=8.0
--enable-msdblib
make && make
install
配置freetds配置文件:
Host填sqlserver服务器地址
Port 填端口
Tds version=8.0
Client charset = utf8
3.安装php_dblib模块
/usr/local
/php5/bin/phpize
通过pdo_dblib链接数据库
--with-pdo-dblib路径指的是freetds的安装路径
./configure
--with-php-config=/usr/local/php5/bin/php-config
--with-pdo-dblib=/usr/local/freetds
make
make install
pdo连接数据库的时候:
记得是用dblib,而不是sqlserver
try{
$link=new
PDO("dblib:host=souyue91;dbname=dbname","dbuser","dbpass");
}catch(PDOException
$e){
echo $e->getMessage();
}
Host填的是freetds里面配的souyue91