lol纳尔皮肤狂狮:Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21' 这个是什么问题怎么来修改啊?

来源:百度文库 编辑:神马品牌网 时间:2024/05/10 20:06:01
提示第7行错误的。
怎么来解决啊?
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'
ODBC 驱动程序不支持所需的属性。

/shop.asp,行7

程序:
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<table width="578" border="0" cellspacing="7" cellpadding="0">
<tr>
<td width="193" height="160" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<% query="select * from v_pdtlst where g_pdtcls="&pcid&" and g_shw=1 order by g_odr"
rs.open query,conn,1,1
if rs.eof then
response.write "<br><br><center>该类别下当前还没有产品!</center>"
end if
i=1
allnum=rs.recordcount
while not rs.eof
%>
<tr>
<td colspan="2"><div align="center"><strong><%=pdtclsnme&trim(rs("g_prd"))%></strong></div></td>
</tr>
<tr>
<td colspan="2"><div align="center"><span class=enbold><strong><a href="set_frm.asp?gid=<%=rs("g_prd")%>"><img src="<%=rs("g_pic")%>" border="0" width=130 height=70></a></td>
</tr>
<tr>
<td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="28%"><div align="center"><b><font color="#FF0000">型号:</font></b></div></td>
<td width="72%"><b><%=trim(rs("g_nme"))%>(<%=trim(Rs("g_prd"))%>型)</b></td>
</tr>
<tr>
<td><div align="center"><b><font color="#FF0000">价格:</font></b></div></td>
<td><b>
<%
query="select * from v_prclst where p_tmetpe>=5 and p_prd='"&rs("g_prd")&"' and p_cls="&p_cls&" order by p_tmetpe ,p_yar"
rs1.open query,conn,1,1
j=1
while j<=3 and ( not rs1.eof )
p_yar=cstr(rs1("p_yar"))
if p_yar="1" then
p_yar=""
end if
response.write rs1("p_prc")&"元/"&p_yar&tmenmes(rs1("p_tmetpe"))&" "
rs1.movenext
j=j+1
wend
rs1.close
%>
</b></td>
</tr>
</table></td>
</tr>
<tr>
<td width="27%"><b><font color="#FF0000">内容:</font></b></td>
<td width="73%"><span style="line-height:160%"><%=html_encode(trim(rs("g_cnt")))%></span></td>
</tr>
<tr>
<td colspan="2"><div align="center"><a href="set_frm.asp?gid=<%=rs("g_prd")%>"><img src="/imgs/kaitong.gif" border="0"></a></div></td>
</tr>
<% if i<allnum then %>
</table>
<%
end if
i=i+1
rs.movenext
wend
rs.close %>
</td>
<td width="193" height="160" valign="top"> </td>
<td width="193" height="160" valign="top"> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>

</tr>
</table>

query 是查询语句,在这之前的数据连接语句呢??

rs 与 conn 没有定义

conn 为连接字符串

rs 为 OleDbConnection