Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)asp留言簿错误

来源：百度知道编辑：UC知道时间：2024/07/02 15:20:39

代码:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>

<body>
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("example3.mdb")
name=request.form("name")
tel=request.form("tel")
message=request.form("message")
exec="insert into guestbook(name,tel,message)values('"+name+"',"+tel+",'"+message+"')"
conn.execute exec
conn.close
set conn=nothing
response.write "记录添加成功!"
%>

set rs=server.createobject("adodb.recordset")
exec="insert into guestbook(name,tel,message)values('"&name&"','"&tel&"','"&message&"')"
rs.open exec,conn,1,3
用conn直接开数据库，效率比recordset高，但是有时容易出问题