Welcome

首页 / 网页编程 / PHP / php adodb连接带密码access数据库实例,测试成功

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

$db->Connect($myDSN);         
$recordSet = $db->Execute("select * from tt");    
if (!$recordSet)     
        print $db->ErrorMsg();    
else   
while (!$recordSet->EOF) {    
        print $recordSet->fields[0]." ".$recordSet->fields[1]."<BR>";    
        $recordSet->MoveNext();    
}    

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