linux+php连接mssql

发布时间：2014-09-05 16:57:06作者：知识屋

因为环境需要，linux+php连接mssql
安装加载freetds模块过程省略网上很多

yum install unixODBC*
在/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 etc]# cat freetds.conf
#   $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
;client charset = UTF-8
# A typical Sybase server
# A typical Microsoft server
[egServer70]
        host = 51.102.111.123
        port = 1433
        tds version = 8.0

[root@xafcbackup etc]# cat /data/caijishuju/t.php
<?php
$conn=mssql_connect("egServer70","sa",xaj!@34);
       //test
           if($conn)
       {
       echo "ok";
       } else

           {
           echo "no";
           }
?>

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