$conn=new COM("ADODB.Connection"); $dsn="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=".realpath("data.mdb").";Uid=Admin;Pwd=BDC2002Data;"; $conn->open($dsn); $sql="select * from dict"; $rs=$conn->Execute($sql); $row="0"; while(!$rs->EOF) { for ($i=0;$i<$rs->Fields->count;$i++) { if ($i==0) { $string.=$rs->Fields($i)->Value; continue; } $string.='|'.$rs->Fields($i)->Value; } $string.="\n"; if ($row==300) { //break; } $row++; $rs->MoveNext(); echo $string; }
//ODBC连接数据库 $cnx=odbc_connect("program","",""); if(!$cnx){ error_handler("ODBC_connect连接有错误",$cnx); } $cur=odbc_exec($cnx,"select * from diary"); if (!$cur){ error_hander("Odbc_exec运行有错,没有指针传回",$cur); } //取出成功的数据 $cur=odbc_exec($cnx,"select * from diary order by id desc"); while(odbc_fetch_row($cur)) { $title=odbc_result($cur,2); $id=odbc_result($cur,1); $content=odbc_result($cur,4); $date=odbc_result($cur,5); $images=odbc_result($cur,3); }
$dsn="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=".realpath("data.mdb").";Uid=Admin;Pwd=BDC2002Data;";
$conn->open($dsn);
$sql="select * from dict";
$rs=$conn->Execute($sql);
$row="0";
while(!$rs->EOF)
{
for ($i=0;$i<$rs->Fields->count;$i++)
{
if ($i==0)
{
$string.=$rs->Fields($i)->Value;
continue;
}
$string.='|'.$rs->Fields($i)->Value;
}
$string.="\n";
if ($row==300)
{
//break;
}
$row++;
$rs->MoveNext();
echo $string;
}
$cnx=odbc_connect("program","","");
if(!$cnx){
error_handler("ODBC_connect连接有错误",$cnx);
}
$cur=odbc_exec($cnx,"select * from diary");
if (!$cur){
error_hander("Odbc_exec运行有错,没有指针传回",$cur);
}
//取出成功的数据
$cur=odbc_exec($cnx,"select * from diary order by id desc");
while(odbc_fetch_row($cur))
{
$title=odbc_result($cur,2);
$id=odbc_result($cur,1);
$content=odbc_result($cur,4);
$date=odbc_result($cur,5);
$images=odbc_result($cur,3);
}
感觉ODBC不如COM的方便。
添加你的access数据源!
用你的方法在访问网络硬盘的时候出现错误:
用subst J: C:\..\db1.mdb 命令虚拟个盘以后直接访问J:
//----------------
$dbc=new com("adodb.connection");
$dbc->open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=J:\\db1.mdb");//\\d:\\Inetpub
$rs=$dbc->execute("select * from countip");
----------------------------------------------------------
Warning: (null)(): Invoke() failed: 发生意外。 Source: Microsoft JET Database Engine Description: 'J:\db1.mdb'不是一个有效的路径。 确定路径名称拼写是否正确,以及是否连接到文件存放的服务器。 in D:\Inetpub\index.php on line 86是怎么回事啊?????????????????????????
$Conn=new Com("Adodb.Connection") or die('can not start ActiveX Data Objects');
$Connstr = "provider=Microsoft.Jet.OLEDB.4.0;Data Source=".realpath("mydb/db.mdb");
$Conn->Open($Connstr);
?>