20,397
社区成员




- $db1="D:\phpstudy_pro\WWW\Data.mdb";
- $db2=realpath("Data.mdb");
- $db3=$_SERVER['DOCUMENT_ROOT'] . "/Data.mdb";
-
-
- //第一种方式正常
- $conn = new com("ADODB.Connection");
- $connstr = "DRIVER={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ=" . $db2;
- $connid=odbc_connect($connstr,"","",SQL_CUR_USE_ODBC );
- $sql="select * From Users";
- $rs=odbc_exec($connid,$sql);
- echo odbc_result($rs,"LoadPass");
- odbc_close($connid);
- //这种方式可以正常查询记录
-
- //地二种方式错误
- $conn = @new com("ADODB.Connection") or die ("ADO连接失败!");
- //$connstr = "DRIVER={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ=" . $db2;
- $connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . $db2;
- $conn->Open($connstr); //这行提示:Fatal error: in
为什么第二种方式不行呢?折磨我两天了
系统WIN11(64位)
PHPStudy(PHP 7.3+APACHE2.4.39)
$db1="F:\WWW\Data.mdb";
$conn = new com("ADODB.Connection");
$connstr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" . $db1; //尝试这个Open处 Fatal error 错误
$connstr = "Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=" . $db1; //尝试这个Open处 Fatal error 错误
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . $db1; //尝试这个Open处 Fatal error 错误
$connstr = "PROVIDER=Microsoft.ACE.OLEDB.12.0; Data Source=" . $db1; //尝试这个Open处 Fatal error 错误
$connstr = "PROVIDER=Microsoft.ACE.OLEDB.16.0; Data Source=" . $db1; //成功
echo $connstr . "<br>";
$conn->Open($connstr);
echo "<br><font style='color:green;font-weight:bold;'>连接数据库成功</font><br>";
$conn->Execute("Insert into T (A) values ('zhongguo')"); //成功
$conn->Execute("UpDate T Set A='dfagtaeyrg' Where ID=1"); //成功
$conn->Execute("Delete From T Where ID=2"); //成功
$conn->Execute("Select A From T Where ID=3"); //尝试这个Open处 Fatal error 错误
$result=$conn->Execute("Select * From T Where ID=3"); //尝试这个Open处 Fatal error 错误
$rs = new COM("ADODB.RecordSet");
$rs->Open("Select * From T Where ID=3",$conn,1,1); //尝试这个Open处 Fatal error 错误
echo $rs->Field['A'].value;
现在是可以添加 ,修改,删除 ,就是不可以查询记录?
快疯了
$db1="F:\WWW\Data.mdb";
$conn = new com("ADODB.Connection");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . $db1;
$connstr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" . $db1;
$connstr = "DRIVER={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ=" . $db1;
echo $connstr . "<br>";
$conn->Open($connstr);
三种方法都出错:错误一样
Fatal error: in F:\WWW\Index.php on line 57