点击登录
  • 欢迎访问无限星辰技术博客,推荐使用最新版火狐浏览器和Chrome浏览器访问本网站 QQ群
  • 如果您觉得本站非常有看点,那么赶紧使用Ctrl+D 收藏无限星辰吧
  • 无限星辰的淘宝店铺已经开张了哦,传送门:http://

Linux php5.3 安装Mssql 2008支持

LINUX服务器 crx349 2275次浏览 0个评论 扫描二维码

1.下载freetds 并安装

1
2
3
4
5
wget ftp://ftp.freetds.org/pub/freetds/current/freetds-current.tar.gz
tar -zvxf freetds-current.tar.gz
cd freetds-dev.0.99.479
./configure --prefix=/usr/local/freetds --with-tdsver=7.2 --enable-msdblib --with-gnu-ld --enable-shared --enable-static 
make && make install

2安装php5.3 mssql扩展

1
2
3
4
5
6
7
wget http://cn2.php.net/distributions/php-5.3.29.tar.gz
tar -zvxf php-5.3.29.tar.gz
cd php-5.3.29/ext/mssql
/www/wdlinux/nginx_php-5.3.29/bin/phpize //生成编译配置文件 
./configure --with-php-config=/www/wdlinux/nginx_php-5.3.29/bin/php-config --with-mssql=/usr/local/freetds 
make 
make install

编译完成生成 mssql.so,修改php.ini,将该模块载入:

1
extension=/path/to/extension/mssql.so

3.编辑freetds.conf /usr/local/freetds/etc下

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
#   $Id: freetds.conf,v 1.12 2007/12/25 06:02:36 jklowden Exp $  
#  
# This file is installed by FreeTDS if no file by the same   
# name is found in the installation directory.    
#  
# For information about the layout of this file and its settings,   
# see the freetds.conf manpage "man freetds.conf".    
 
# Global settings are overridden by those in a database  
# server specific section  
[global]  
        # TDS protocol version  
;       tds version = 4.2  
 
        # Whether to write a TDSDUMP file for diagnostic purposes  
        # (setting this to /tmp is insecure on a multi-user system)  
;       dump file = /tmp/freetds.log  
;       debug flags = 0xffff  
 
        # Command and connection timeouts  
;       timeout = 10  
;       connect timeout = 10  
 
        # If you get out-of-memory errors, it may mean that your client  
        # is trying to allocate a huge buffer for a TEXT field.    
        # Try setting 'text size' to a more reasonable limit   
        text size = 64512  
 
# A typical Sybase server  
[egServer50]  
        host = symachine.domain.com  
        port = 5000  
        tds version = 5.0  
 
# A typical Microsoft server  
[egServer70]  
        host = ntmachine.domain.com  
        port = 1433  
        tds version = 7.0  
[sql2008]  
        host = ntmachine.domain.com  
        port = 1433  
        tds version = 7.2

5.测试

1
/usr/local/freetds/bin/tsql -S sql-server-2000 -U sa -P test

出现

1
2
3
4
locale is "zh_CN.UTF-8"  
locale charset is "UTF-8"  
using default charset "UTF-8"  
1>

6.成功
7.程序使用

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
< ?php 
try { 
$hostname='218.x.x.x';//注意,这里和上面不同,要直接用IP地址或主机名 
$port=1433;//端口 
$dbname="user";//库名 
$username="database";//用户 
$pw="passwd";//密码 
$dbh= new PDO("dblib:host=$hostname:$port;dbname=$dbname","$username","$pw"); 
} catch (PDOException $e) { 
echo"Failed to get DB handle: ".$e->getMessage() ."n"; 
exit; 
} 
echo'connent MSSQL succeed'; 
$stmt=$dbh->prepare("select * from xmspace_net"); 
$stmt->execute(); 
while ($row=$stmt->fetch()) { 
print_r($row); 
} 
unset($dbh); unset($stmt); 
?>

测试是否能正常连接mssql2008


无限星辰 , 版权所有丨如未注明 , 均为原创丨本网站采用BY-NC-SA协议进行授权 , 转载请注明Linux php5.3 安装Mssql 2008支持
喜欢 (0)
[]
分享 (0)

您必须 登录 才能发表评论!