2017神武卡级30限制表:[Microsoft][ODBC Microsoft Access Driver] 参数不足,期待是 1。
来源:百度文库 编辑:高校问答 时间:2024/05/12 01:07:01
<%@LANGUAGE="JAVASCRIPT"%>
<%
var title=Request("newstitle");
%>
<%
conn=Server.CreateObject("ADODB.Connection");
conn.Open ("driver={Microsoft Access Driver (*.mdb)};dbq=" + Server.MapPath("2005.mdb"));
sql="Select * from news where newstitle="+title;
rs=conn.Execute(sql);
%>
<html>
<body><table border=0 cellpadding=2 style="font:10pt" style="background:white;font: 12pt;color:black">
<tr style="background:#aaaadd;font: 12pt;color:black">
<th>新闻标题</th><th>新闻内容</th><th>添加时间</th></tr>
<%
Response.Write("<tr>");
Response.Write("<td>" + rs("newstitle") + "</td>");
Response.Write("<td>" + rs("newscontent") + "</td>");
Response.Write("</tr>");
%>
</table>
</body>
</html>
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] 参数不足,期待是 1。
/detail.asp, 第 10 行
<%
var title=Request("newstitle");
%>
<%
conn=Server.CreateObject("ADODB.Connection");
conn.Open ("driver={Microsoft Access Driver (*.mdb)};dbq=" + Server.MapPath("2005.mdb"));
sql="Select * from news where newstitle="+title;
rs=conn.Execute(sql);
%>
<html>
<body><table border=0 cellpadding=2 style="font:10pt" style="background:white;font: 12pt;color:black">
<tr style="background:#aaaadd;font: 12pt;color:black">
<th>新闻标题</th><th>新闻内容</th><th>添加时间</th></tr>
<%
Response.Write("<tr>");
Response.Write("<td>" + rs("newstitle") + "</td>");
Response.Write("<td>" + rs("newscontent") + "</td>");
Response.Write("</tr>");
%>
</table>
</body>
</html>
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] 参数不足,期待是 1。
/detail.asp, 第 10 行
错误的性质应该是连接字符串不正确,将
conn.Open ("driver={Microsoft Access Driver (*.mdb)};dbq=" + Server.MapPath("2005.mdb"));
改为
conn.Open ("provider=microsoft.jet.oledb.4.0;data source=" + Server.MapPath("2005.mdb"));
即可,如果仍然报错,请检查数据库文件的位置是否正确
[Microsoft][ODBC
[Microsoft][ODBC Microsoft Access Driver]常见错误
[Microsoft][ODBC Microsoft Access Driver] 内存溢出
[Microsoft][ODBC Microsoft Access Driver] 内存溢出
ODBC数据源管理器中无microsoft odbc for oracle
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)[Microsoft][ODBC Microsoft Access Driver] ?
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)[Microsoft][ODBC Microsoft Access Driver] ?
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver]
Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'[Microsoft][ODBC Microsoft Access Driver]
[microsoft][odbc microsoft access driver]参数不足,期待是1