php mssql image,linux+php连接mssql

因为环境需要，linux+php连接mssql

安装加载freetds模块过程省略网上很多

在/etc/profile

中加入export PATH="$PATH:/usr/local/freetds/bin"

#echo "/usr/local/freetds/lib" >> /etc/ld.so.conf

source /etc/profile

#ldconfig

再配置freetds

/usr/local/freetds/etc

[root@xafcbackup ~]# cat /usr/local/freetds/etc/freetds.conf

[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

host = 51.102.121.217

port = 1433

tds version = 8.0

client charset = GBK

[root@xafcbackup etc]# cat /data/caijishuju/t.php

$conn=mssql_connect("51.102.121.217","sa",xaj!@34);

//test

if($conn)

{

echo "ok";

} else

{

echo "no";

}

?>

程序配置文件连接的是定义的名称而不是ip否则不能连接！

参考http://coralzd.blog.51cto.com/90341/525106

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！