在Centos上使用php连接mssql


connect mssql using php on Centos

我已经安装了freeds,我想通过php连接到mssql服务器。我正在使用centos

root@server [~/php]# tsql -C
Compile-time settings (established with the "configure" script)
                            Version: freetds v0.91
             freetds.conf directory: /usr/local/etc
     MS db-lib source compatibility: no
        Sybase binary compatibility: no
                      Thread safety: yes
                      iconv library: yes
                        TDS version: 5.0
                              iODBC: no
                           unixodbc: yes
              SSPI "trusted" logins: no
                           Kerberos: no
我用来连接到mssql服务器的php代码。(它位于子目录中)我能够通过本地mssql服务器2008连接到远程mssql服务器。
<?php
// Older FreeTDS installations need the FREETDSCONF Environment variable
putenv('FREETDSCONF=../usr/local/etc/freetds.conf');
// Current release of FreeTDS uses the FREETDS environment variable. So we set both to be sure
putenv('FREETDS=../usr/local/etc/freetds.conf');
$mssql = mssql_connect('116.214.26.236' , 'dbname', 'password');
//mssql_select_db('myDb',$mssql);

if (!$mssql) {
    die('Something went wrong while connecting to MSSQL');
}else echo 'Success';
?>

TDS配置文件

#   $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 = 116.214.26.236
    port = 1433
    tds version = 7.0

我得到的错误

警告:mssql_connect() [function。mssql-connect]:无法连接到服务器:116.214.26.236在/home/butter/public_html/investonline/mssql.php第6行连接到MSSQL时出错

请告诉我我错在哪里。

我在谷歌上搜索过一些博客说下面一行的值必须是yes,MS db-lib源代码兼容性:no

php.ini配置文件

mssql
MSSQL Support   enabled
Active Persistent Links 0
Active Links    0
Library version FreeTDS
Directive   Local Value Master Value
mssql.allow_persistent  On  On
mssql.batchsize 0   0
mssql.charset   no value    no value
mssql.compatability_mode    Off Off
mssql.connect_timeout   5   5
mssql.datetimeconvert   On  On
mssql.max_links Unlimited   Unlimited
mssql.max_persistent    Unlimited   Unlimited
mssql.max_procs Unlimited   Unlimited
mssql.min_error_severity    10  10
mssql.min_message_severity  10  10
mssql.secure_connection On  On
mssql.textlimit Server default  Server default
mssql.textsize  Server default  Server default
mssql.timeout   60  60

也让我知道我应该如何获得日志捕获,以便我可以知道在哪一步有一个错误。

为什么我不能连接到mssql服务器

您可以使用PDO php库连接sql server,您可以这样使用$output = new PDO ('mssql:host=SERVERHOST;dbname= dbname ','DBUSERNAME','DBPASSWORD');

进入这个链接并按它说的做。最好使用微软的驱动程序。

http://strangenut.com/blogs/dacrowlah/archive/2012/04/13/installing-and-using-the-microsoft-sql-server-odbc-driver-for-linux.aspx