应该用下面的方法连接(windows下,linux只能用odbc):<?PHP $db_connection = new COM("ADODB.Connection"); /* Se il DSN è System funziona in entrambi i modi Se il DSN è User funziona solo con: la stringa: DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=".realpath("prova.mdb") ." ;DefaultDir=".realpath("/"); */ $db_connstr ="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=".realpath("prova.mdb") ." ;DefaultDir=".realpath("/"); $db_connstr = "prova"; $db_connection->open("prova"); $rs = $db_connection->execute("SELECT * FROM table1"); $rs_fld0 = $rs->Fields(0); $rs_fld1 = $rs->Fields(1); while (!$rs->EOF) { echo "$rs_fld0->value $rs_fld1->value\n"; $rs->MoveNext(); /* updates fields! */ } $rs->Close(); $db_connection->Close(); ?>
还有你是在windows下还是linux下啊?如果是linux下,ado包装了吗?
$db_connection = new COM("ADODB.Connection"); /*
Se il DSN è System funziona in entrambi i modi
Se il DSN è User funziona solo con: la stringa:
DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=".realpath("prova.mdb") ." ;DefaultDir=".realpath("/");
*/
$db_connstr ="DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=".realpath("prova.mdb") ." ;DefaultDir=".realpath("/"); $db_connstr = "prova"; $db_connection->open("prova"); $rs = $db_connection->execute("SELECT * FROM table1");
$rs_fld0 = $rs->Fields(0);
$rs_fld1 = $rs->Fields(1);
while (!$rs->EOF) {
echo "$rs_fld0->value $rs_fld1->value\n";
$rs->MoveNext(); /* updates fields! */
}
$rs->Close();
$db_connection->Close(); ?>