为什么我一直连不上数据库??
以下是代码,大家帮忙看看~~
数据库文件在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()只是用来构造一个绝对路径,并不管该路径是否存在。