asp错误Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)的问题
来源:百度知道 编辑:UC知道 时间:2024/06/05 09:13:17
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
ODBC 驱动程序不支持所需的属性。
/exam6.asp, 第 8 行
浏览器类型:
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/525.13 (KHTML, like Gecko) Chrome/0.2.149.27 Safari/525.13
网页:
POST 32 ??? /exam6.asp
POST Data:
name=d&tel=d&Submit=%CC%E1%BD%BB
<%
name=request.form("name")
tel=request.form("tel")
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("guestbook.mdb")
exec="select * from guest where name="+name+" and tel="+tel
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
%>
<html>
<head>
<title>无标题文档</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
ODBC 驱动程序不支持所需的属性。
/exam6.asp, 第 8 行
浏览器类型:
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/525.13 (KHTML, like Gecko) Chrome/0.2.149.27 Safari/525.13
网页:
POST 32 ??? /exam6.asp
POST Data:
name=d&tel=d&Submit=%CC%E1%BD%BB
<%
name=request.form("name")
tel=request.form("tel")
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("guestbook.mdb")
exec="select * from guest where name="+name+" and tel="+tel
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
%>
<html>
<head>
<title>无标题文档</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
根据它的提示 应该是驱动程序写的不对.我没有用过这种写法.
我给你另一种方法吧,也许有用:
set conn=server.CreateObject("ADODB.Connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.mappath("abc.mdb")
set rs=server.CreateObject("ADODB.recordset")
set rs=conn.execute("select * from 表名")
这个绝对管用 我一直在用的 呵呵
rs.open exec,conn,1,1
改了
rs.open exec,conn,3,3
把exec="select * from guest where name="+name+" and tel="+tel 改成
exec="select * from guest where name='"&name&"' and tel='"&tel&"'"
ASP问题:Microsoft OLE DB Provider for SQL Server 错误 '80004005'
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)asp留言簿错误
ASP数据库连接的问题:Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'
为什么asp编程时出现(Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14' )
asp中数据库更新出现“Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e2f' ”
microsoft ole db provider for sql server 错误‘ 80004005’
Microsoft OLE DB Provider for SQL Server (0x80040E14)错误
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)错误
asp问题Microsoft OLE DB Provider for ODBC Drivers (0x80040E0C)
asp问题Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)