linux centos6.4 php接続sql server 2008

1、 SQL Server freetds

yum search freetds

yum install freetds php-mssql

またはコンパイルインストールをダウンロードする
 2、 /etc/freetds.conf [server2008]          host = 192.168.70.119          port = 1433          tds version = 7.0      client charset = utf8
 
再起動したほうがいい3、  ./tsql -S 192.168.0.109 -U -P -D 1> sql 1>select * from table; 2>go 
4、コードテスト接続
 

<?php
$server = 'server2008 ';
$link = mssql_connect($server, 'sa', '123456');
if (!$link) {
die('Something went wrong while connecting to MSSQL');
}
?>

5、PDO接続Sql serverのテスト
ここでdblibを使いました

<?php
$db = new PDO("dblib:host=192.168.70.119;dbname=master","sa","123456");
$sql = "select top 3 *  from spt_values";
$res = $db->query($sql);
while ($row = $res->fetch()){
  print_r($row);
}
$res = null;
$db = null;
?>

結果:
Array ( [name] => jiqing [0] => jiqing [number] => 1 [1] => 1 [type] => A [2] => A [low] => [3] => [high] => [4] => [status] => 0 [5] => 0 ) Array ( [name] => pub [0] => pub [number] => 2 [1] => 2 [type] => A [2] => A [low] => [3] => [high] => [4] => [status] => 0 [5] => 0 ) Array ( [name] => sub [0] => sub [number] => 4 [1] => 4 [type] => A [2] => A [low] => [3] => [high] => [4] => [status] => 0 [5] => 0 )