FreeTDS (freetds.org) is a set of libraries that allow Drupal/PHP(Your Program) to communicate with MS SQL Server.

Configure freetds and iODBC :

   1. Download freetds and iodbc from :
      http://www.iodbc.org/downloads/iODBC/libiodbc-3.52.7.tar.gz
      ftp://ftp.ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgz

   2. Extract and configure iODBC:
      cd $HOME/local
      tar -xvf libiodbc-3.52.7
      cd libiodbc-3.52.7

      ./configure—prefix=$HOME/local/libiodbc—exec-prefix=$HOME/local/libiodbc—enable-gui=no
      make
      make install

   3. Extract and configure FreeTDS:
      cd $HOME/local
      tar -xvf freetds-0.82.tar.gz
      cd freetds-0.82

      ./configure -prefix=$HOME/local/freetds—with-iodbc=$HOME/local/libiodbc—with-tdsver=8.0
      make
      make install

   4. Locate tsql:
      find $HOME -name “tsql”

      Result:
      /home/root/local/freetds-0.82/src/apps/tsql
      /home/root/local/freetds/bin/tsql

   5. Copy all files from /home/root/local/freetds/bin to /home/root/bin
      cp /home/root/local/freetds/bin/* to /home/root/bin

   6. Connection Validation : Create sqlquery.sql file and try to connect MSSQL and use tsql from PHP:

      sqlquery.sql Snippet :
      use master_db
      select * from user_master
      go

      PHP Snippet:
      exec(”/home/root/bin/tsql -S MSSQL_Server_IP -U ‘Domain\username’ -P ‘password’ < /home/root/public_html/sqlquery.sql”, $output, $return);
      echo “Dir returned $return, and output:\n”;
      var_dump($output);