关于查询！

[VFP]

出错提示：
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'

ODBC driver does not support the requested properties.

/1/duo_cx_jg.asp, 行44

<!--#include file="dbconn.inc" -->
<%xm=trim(request("xm"))
condition=""
rq1=""
if xm <> "" then condition=" 姓名->"&xm&" "
nian=trim(request("nian"))
yue=trim(request("yue"))
ri=trim(request("ri"))
if nian <> "" then
rq=nian
rq1=nian&"年"
end if
if yue <> "" then
rq=rq&"-"&yue
rq1=rq1&yue&"月"
end if
if ri <> "" then
rq=rq&"-"&ri
rq1=rq1&ri&"日"
end if
if rq1 <> "" then condition=condition&"日期->"&rq1&" "
session("name")=name
session("rq")=rq
session("condition")=condition
%>
.......
<%
sql="select * from b where xm like '%"&session("xm")&"%' and convert(char,sj,21) like '%"&session("rq")&"%'"
set rs=server.createobject("adodb.recordset") <--------44行就在此
rs.open sql,conn,1,1
%>

请问错在哪？(ACCESS数据库)日期和姓名联合查询。

[cmsoft]

sql="select * from b where xm like '%"&session("xm")&"%' and sj like '%"&session("rq")&"%'"
response.write sql
response.end
输出SQL，在ACCESS里执行一下

[cmsoft]

sql="select * from b where xm like '%"&session("xm")&"%' and sj like '%"&session("rq")&"%'"
response.write sql
response.end
输出SQL，在ACCESS里执行一下

[blackcatiii]

日期为什么不用datetime类型?
看能否在asp里CDate了
if rq<>"" then
if not isDate(rq) then
response.write "日期格式不正确"
response.end
end if
rq=CDate(rq)
end if
session("rq")=rq

[VFP]

出错提示：
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'

ODBC driver does not support the requested properties.

/1/duo_cx_jg.asp, 行44

怎么解决?