title: connect mssql using php on Centos
body: <p>I have installed freetds and I want to connect to mssql server via php. I am using centos.</p>
  
  <pre><code>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
  </code></pre>
  
  <p>The php code I use to connect to mssql server. (Its located in a subdirectory) I am able to connect to remote mssql server via local mssql server 2008.</p>
  
  <pre><code>&lt;?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';
  
  ?&gt;
  </code></pre>
  
  <p>My TDS config file</p>
  
  <pre><code>#   $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
  </code></pre>
  
  <p>The error that I get</p>
  
  <p>Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 116.214.26.236 in /home/butter/public_html/investonline/mssql.php on line 6
  Something went wrong while connecting to MSSQL</p>
  
  <p>Please guide me on where am I getting wrong.</p>
  
  <p>I have searched on google some blogs says the below line value has to be yes,
  MS db-lib source compatibility: no</p>
  
  <p>My php.ini conf file</p>
  
  <pre><code>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
  </code></pre>
  
  <p>Also let me know how should I get the logs captured so that I can know at what step there is an error.</p>
  
  <p>Also why am I not able to connect to mssql server.</p>