php使用pdo odbc访问sql server2000

前提是：先在操作系统中配置好ODBC源，如果是Linux系统要安装unixODBC和freeTDS

<?php
   $dbh= new PDO('odbc:attt', 'sa', 'sa');
   $dbh->prepare("set character_set_client = utf8");
   $query = "select userid,name,gender,convert(varchar(19),birthday,120) as bd from userinfo";
   $stmt = $dbh->prepare("$query");
   $stmt->execute();
   while ($row = $stmt->fetch()) {
       //print_r($row);
    echo $row['name']." ".$row['bd']."<br>";
   }
   unset($dbh); unset($stmt);
   ?>