The '/etc/freetds/freetds.conf file:

[MY_DB]
       host = 10.0.0.1
       port = 1433
       tds version = 7.0


The 'test_mssql.php' script:

<?php

require_once 'DB.php';

// DSN : 'mssql://user:passwd@server/database'
$dsn = 'mssql://sa:s3cr3t@MY_DB/my_database';

$db = DB::connect($dsn);

if (DB::isError($db)) {
   die($db->getMessage());
}

print "DB connection appeared to be successful.<BR>\n";

if (test_database() == false) {
        print "Database test failed.<BR>\n";
}

exit;

function test_database()
{
        global $db;

        $sql = "SELECT id, value FROM my_table";

        print $sql . "<BR>\n";

        $rows = $db->getAll($sql);

        if (DB::isError($rows)) {
                echo $db->getMessage();
                return false;
        }
        if (empty($rows)) {
                echo "No rows.<br>\n";
                return false;
        }
        foreach ($rows as $v) { // lets flatten
        the array
              print $v[0] . ", " . $v[1]
        . "<BR>\n";
        }
        return true;
}

?>