用PHP连接Access出现的错误怎么解决???
itic 2006-01-10 10:10:58 <?php
$db_path = "C:/cgi/data/db.mdb";
$conn = new COM('ADODB.Connection');
$accessdsn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=".$db_path;
$conn->Open($accessdsn);
$page_sql="select * from php_guest";
$rs = new COM('ADODB.recordset');
$rs->open($page_sql,$conn,1,1);
echo $rs->Fields["szd_title"];
?>
不知道怎么搞的。这段代码输出的是:Object
也没有显示什么错误
我同样改写成ASP代码
<%
set conn = Server.CreateObject("ADODB.Connection")
db = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("data\db.mdb")
conn.open db
sql="select * from php_guest"
set rs = Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
response.write rs.fields("szd_title")
%>
ASP输出的是正确的
为什么啊