帮忙看看问题出哪了阿？
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'
ODBC 驱动程序不支持所需的属性。
/search.asp，行 549
dim connstr2
connstr2="DBQ="+server.mappath("../database/mydb.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr2
set rs=server.CreateObject("adodb.recordset")
dim bigclass,smallclass,sheng,shi,name
bigclass=trim(request("anclassid"))
smallclass=trim(request("nclassid"))
sheng=trim(request("dsheng"))
shi=trim(request("dshi"))
jiage=trim(request("jiage"))
name=trim(request("searchkey"))
name=replace(name,"'","''")
Sql= " Select * from shop_books where 1=1 "
if bigclass<>0 then
select case action
case "1"
if bigclass <>"" then
sql= sql & " and anclassid= '"&bigclass&"'"
end if
if smallclass <>"" then
sql= sql & " and nclassid= '"&smallclass&"'"
end if
if sheng <>"" then
sql= sql & " and dsheng= '"&sheng&"'"
end if
if shi <>"" then
sql= sql &" and dshi= '"&shi&"'"
end if
if name <>"" then
sql= sql &" and bookname like '%"&name&"%' and huiyuanjia<"&jiage&" "
end if
case "2"
if bigclass <>"" then
sql= sql & " and anclassid= '"& bigclass &"'"
end if
if smallclass <>"" then
sql= sql & " and nclassid= '"& smallclass &"'"
end if
if sheng <>"" then
sql= sql & " and dsheng= '"& sheng &"'"
end if
if shi <>"" then
sql= sql&" and dshi= '"& shi &"'"
end if
if name <>"" then
sql= sql&" and pingpai like '%"& selectname &"%' and huiyuanjia<"&jiage&" "
end if
case "3"
if bigclass <>"" then
sql= sql & " and anclassid= '"& bigclass &"'"
end if
if smallclass <>"" then
sql= sql & " and nclassid= '"& smallclass &"'"
end if
if sheng <>"" then
sql= sql & " and dsheng= '"& sheng &"'"
end if
if shi <>"" then
sql= sql&" and dshi= '"& shi &"'"
end if
if name <>"" then
sql= sql&" and bookzz like '%"& selectname &"%' and huiyuanjia<"&jiage&" "
end if
case "4"
if bigclass <>"" then
sql= sql & " and anclassid= '"& bigclass &"'"
end if
if smallclass <>"" then
sql= sql & " and nclassid= '"& smallclass &"'"
end if
if sheng <>"" then
sql= sql & " and dsheng= '"& sheng &"'"
end if
if shi <>"" then
sql= sql&" and dshi= '"& shi &"'"
end if
if name <>"" then
sql= sql&" and bookcontent like '%"& name &"%' and huiyuanjia<"&jiage&" "
end if
case else
end select
end if
------549行------ rs.open sql,conn,1,1
[解决办法]
你自己试着
RESPONSE.WRITE SQL
看SQL的值是什么
[解决办法]
检查一下：
1. 链接成功与否
2. 语句是否有问题。把SQL语句打印出来看看。在数据库的环境运行一下就知道是否有问题。
3. 就算是在数据库环境通过，也要检查是否有保留字，ODBC可能会检查保留字是否被使用的。
