ODBC 驱动程序不支持所需的属性.

来源：百度知道编辑：UC知道时间：2024/07/02 12:48:18

<%
dim rs,sql,id,i,str2,username,tupian,objFSO,fileExt,sql1,rs1,sql2,rspower
username=request.cookies("cnmai")("username")
id=trim(request("selectedid"))
if trim(id)="" then
response.write "<script language=JavaScript>" & chr(13) & "alert('没有选择记录！');" & "history.back()" & "</script>"
response.end
end if
str2=split(id,",")
set rs=server.createobject("adodb.recordset")
set rspower=server.createobject("adodb.recordset")
'检测是否有权限
for i=0 to ubound(str2)
sql="select * from [user] where id="&cstr(str2(i))
rs.open sql,conn,1,1
if not rs.eof then
sql="select * from class1 where id="&rs("hangye")&" "
rspower.open sql,conn,1,3
''

sql="delete from [user] where id="&cstr(str2(i))
rs.open sql,conn,1,3
sql1="delete from [shoucang] where scid="&cint(str2(i))&" "
rs.open sql1,conn,1,3
sql2="delete from [hf] where xxid="&cint(str2(i))&" "
rs.open sql2,conn,1,3
上面这些是不能连用的，每次执行应该close,要不会出错的。
sql="delete from [user] where id="&cstr(str2(i))
rs.open sql,conn,1,3
rs.close
sql1="delete from [shoucang] where scid="&cint(str2(i))&" "
rs.open sql1,conn,1,3
rs.close
sql2="delete from [hf] where xxid="&cint(str2(i))&" "
rs.open sql2,conn,1,3

conn 没有定义 ...

把头文件引用改成这样 ...