Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'
[Microsoft][ODBC Microsoft Access Driver] 表达式中的类型不匹配。

我的机器是win2000

conn.asp 页是这样写的
<%

db="database/jlsxpsm.mdb"

Set conn = Server.CreateObject("ADODB.Connection")

'connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)

connstr="driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath(db)

conn.Open connstr
%>


报错的那页是这样写的
<%
sql="select hw.hw_id As hw_id,hw.hw_name As hw_name,hw.hw_content As hw_content,sort.sort_name As xiaosort_id from hw,sort where hw.xiaosort_id = sort.sort_id order by hw.hw_id desc"

set rs=server.createobject("adodb.recordset")

rs.open sql,conn,1,3
%>

谢谢，问题解决了，改conn.asp页，就把两句话交换了下位置。
不太明白是怎么回事，不过真的就好用了。
<%

db="database/jlsxpsm.mdb"

Set conn = Server.CreateObject("ADODB.Connection")

'connstr="driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath(db)

connstr="provider = Microsoft.JET.OLEDB.4.0;Data Source = " & server.MapPath(db)

conn.Open connstr
%>