php连接access

<?    
include('adodb/adodb.inc.php');           
//实例化db类,链接           
$db = ADONewConnection('ado_access');           
$access = realpath('conn/testData.mdb');            
$myDSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;'.'DATA SOURCE='. $access . ';'."Jet OLEDB:Database Password=;";

$db->Connect($myDSN); 

$in = iconv('utf-8','gbk','丁杰木');
$db->Execute("insert into ezk_primary(primaryType,primaryImage) values('".$in."','nimei')");

$recordSet = $db->Execute('select * from ezk_primary');    
if (!$recordSet)     
        print $db->ErrorMsg();    
else   
while (!$recordSet->EOF) {
  $one = $recordSet->fields[0];
  $two = $recordSet->fields[1];
  $two = iconv('gbk','utf-8',$two);
        print $one.' '.$two.'<BR>';
        $recordSet->MoveNext();    
}    

$recordSet->Close(); # 选择性执行    
$db->Close(); # 选择性执行    
?>

扎客小站：www.ezhake.com