杉菜水姬有p站吗:Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)

来源:百度文库 编辑:高校问答 时间:2024/05/10 23:37:47
<% set conn=server.CreateObject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)}; dbq="&server.MapPath(" db1.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("记录添家成功")
rs.close
set rs=nothing
set conn=nothing
%>

MicrosoftOLEDBProviderforODBCDrivers(0x80040E07)-->sql语句出错(要插入或更新的字段的类型与变量数据类型不匹配)

SQL语句有错误,执行时出错!!