我的asp显示ODBC 驱动程序不支持所需的属性。
代码如下
<!--#include file="conn.asp"-->
<html>
<body>
<p>
<%
dim rec
set rec= Server.CreateObject("ADODB.Recordset")
dim sql
if request("username") & ""="" then
sql="select * from guest where 内容 like '%" & request("title") & "%'"
else
sql="select * from guest where 内容 like '%" & request("title") & "%' and 用户名='" & request("username") & "'"
end if
rec.open sql , conn,1, 1 //这一行有问题
%>
<form id="form1" name="form1" method="post" action="show.asp">
姓名:
<label>
<select name="name" id="name">
<option value="" ></option>
<%do while not rec1.eof
if rec1(0)=request("name") then%>
<option value="<%=rec1(0)%>" selected="selected"><%=rec1(0)%></option>
<%else%>
<option value="<%=rec1(0)%>"><%=rec1(0)%></option>
<%
end if
rec1.movenext
loop%>
</select>
</label>
主题:
<input name="title" type="text" id="title" value="<%=request("title")%>" />
<label>
<input type="submit" name="Submit" value="查询" />
</label>
<label>
<input type="reset" name="Submit2" value="重填" />
</label>
</form>
<table border=1 CELLSPACING=0>
<tr>
<%
for i=0 to rec.fields.count-1
response.write "<td>" & rec(i).name & "</td>"
next
%>
</tr>
<%
do while not rec.eof
%>
<tr>
<%
for i=0 to rec.fields.count-1
response.write "<td>" & rec(i) & "</td>"
next%>
<td><a href="mod.asp?id=<%=rec(0)%>">修改</a>--<a href="del.asp?id=<%=rec(0)%>">删除</a></td>
<%response.write "</tr>"
rec.movenext
loop
rec.close
set rec=nothing
rec1.close
set rec1=nothing
closedb
%>
</body>
</html>
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
ODBC 驱动程序不支持所需的属性。
/留言簿/show.asp, 第 14 行
高手帮忙解决一下,很感谢,