牛津布好还是pu皮好:Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e10'
来源:百度文库 编辑:查人人中国名人网 时间:2024/05/19 22:58:29
我的数据库驱动是:
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
这个是没有错的 我测试过了!
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"
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4E)
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Microsoft OLE DB Provider for SQL Server 求救~~
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Microsoft OLE DB Service Components 错误 '8000ffff'
Microsoft OLE DB Service Components 错误 '8000ffff'
Microsoft OLE DB Provider for ODBC Drivers (0x80040E2F)
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)