牛津布好还是pu皮好:Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e10'

来源:百度文库 编辑:查人人中国名人网 时间:2024/05/07 19:34:37
我的数据库驱动是:
set conn=server.createobject("adodb.connection")
set conn1=server.createobject("adodb.connection")
set conn12=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("database/DATA.mdb")
conn1.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("database/DATA.mdb")
conn12.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("database/DATA.mdb")


MM_conn_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("database/114BSTDATA.mdb")

但是我定义新闻类型的时候出错了

set rs=server.CreateObject("ADODB.Recordset")
sql="select ntitle,ntop,nclick,id,ndt from news order by ntop desc,id desc"
rs.open sql,conn1,1,2

我在news后面增加了where typeid=1

就显示

Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e10'

[Microsoft][ODBC Microsoft Access Driver] 参数不足,期待是 1。

/114bst/index.asp,行 382

请高手帮忙啊!!
by ntop desc,id desc

这个是没有错的 我测试过了!

sql="select ntitle,ntop,nclick,id,ndt from news order by ntop desc,id desc"
order by desc是 按照一定的方式排序,只能跟一个desc
例如
order by id desc 用id排序,最大id值在最上边

sql="select ntitle,ntop,nclick,id,ndt from news order by ntop ,id desc"
或者
sql="select ntitle,ntop,nclick,id,ndt from news order by id,ntop desc"