首页 / 网页编程 / 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(); # 选择性执行
?>