php连接access数据库的问题,郁闷~~

为什么我一直连不上数据库??
以下是代码,大家帮忙看看~~

数据库文件在d:\data\test.mdb

 1   
 2$conn = new com("ADODB.Connection");   
 3$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("d:\data\test.mdb");   
 4$conn->Open($connstr);   
 5$rs = new com("ADODB.RecordSet");   
 6$rs->Open("select * from person",$conn,1,1);   
 7while(! $rs->eof) {   
 8echo $rs->Fields["F_name"]->value."
 9";   
10$rs->MoveNext();   
11}   
12  

提示错误为
Warning: (null)(): Invoke() failed: 发生意外。 Source: Microsoft OLE DB Provider for ODBC Drivers Description: [Microsoft][ODBC Microsoft Access Driver] 文件名无效。

---------------------------------------------------------------

$connstr = "DRIVER={Microsoft Access Driver (.mdb)}; DBQ="d:\\data\\test.mdb";

$connstr = "DRIVER={Microsoft Access Driver (
.mdb)}; DBQ="d:/data/test.mdb";

realpath()只是用来构造一个绝对路径,并不管该路径是否存在。

Published At
Categories with Web编程
comments powered by Disqus