| 网站首页 | 业界新闻 | 小组 | 威客 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛
欢迎加入我们,一同切磋技术
用户名:   
 
密 码:  
共有 1221 人关注过本帖
标题:Microsoft VBScript runtime error '800a0009'错误,麻烦各位帮忙看下,谢谢 ...
只看楼主 加入收藏
笨笨猫学上网
Rank: 1
等 级:新手上路
帖 子:1
专家分:0
注 册:2010-11-14
收藏
 问题点数:0 回复次数:0 
Microsoft VBScript runtime error '800a0009'错误,麻烦各位帮忙看下,谢谢了
在本地测试没问题,上传到空间里面就出现如下问题。各位帮忙看下 谢谢了
Microsoft JET Database Engine error '80040e37'

The Microsoft Jet database engine cannot find the input table or query '˵Ã÷'. Make sure it exists and that its name is spelled correctly.

/jhliaotian001/GLOBAL.ASP, line 37

为什么过一段时间就又提示如上信息了?再过一段又提示如上信息
Microsoft VBScript runtime error '800a0009'
Subscript out of range: '[number: 2]'
/jhliaotian001/system/config.asp, line 3


以下是config.asp完整源码
<%
sub Gohome
'**********************************************************************************
thisisbak=0                '定义是否启用自动备份数据库功能,1为启用,0为不启用
Application("cwjh_datapath")="cwjh_data"        '设置数据库文件夹名称
cwjh_data=Application("cwjh_datapath")&"/jCjHw/lts1/##one1_home.mdb"        '主数据库
cwjh_sub=Application("cwjh_datapath")&"/jCjHw/lts1/##too2_home.mdb"        '副数据库
cwjh_bbs=Application("cwjh_datapath")&"/dkbsbbs/#sCjhsbss.mdb"                '江湖论坛
cwjh_ip=Application("cwjh_datapath")&"/jCjHw/lts1/#33l28a_ip.mdb"                'IP地址数据库
cwjh_stock=Application("cwjh_datapath")&"/jCjHw/lts1/#gpsj.mdb"                '股票数据库
'**********************************************************************************
'以下内容请不要随便修改!有问题请联系军缘网络QQ:115287342
'**********************************************************************************
Application("cwjh_usermdb")="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(cwjh_data)
Application("cwjh_submdb")="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(cwjh_sub)
Application("bbs_connstr")="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(cwjh_bbs)
Application("cwjh_ip")=Server.MapPath(cwjh_ip)
Application("cwjh_stock")=Server.MapPath(cwjh_stock)
Application("jhshowurl")="http://qqshow-item.
Application("cwjh_ver")="帝王旗舰V11.0"
Application("cwjh_npc")=""
Application("cwjh_tltie")="【"&Application("cwjh_chatroomname")&"】欢迎大家光临!购买会员支持江湖发展!"
Set conn=Server.CreateObject("ADODB.CONNECTION")
Set rs=Server.CreateObject("ADODB.RecordSet")
conn.open Application("cwjh_usermdb")
rs.open "SELECT * FROM r order by id",conn
roomcount=""
do while Not rs.Eof
        roomcount=roomcount&rs("a")&"|"&rs("b")&"|"&rs("c")&"|"&rs("d")&"|"&rs("e")&"|"&rs("f")&"|"&rs("g")&"|"&rs("h")&"|"&rs("i")&"|"&rs("j")&"|"&rs("l")&"|"&rs("m")&";"
        rs.MoveNext
loop
rs.close
Application.Lock
Application("cwjh_room")=roomcount
Application.UnLock
'读取配置到缓存
set cw_cfg=conn.execute("select * from 说明 where a='配置'")
if not cw_cfg.eof then Application("cwjh_config")=cw_cfg("c")
set cw_cfg=nothing
'判断备份
isbak=0
if thisisbak=1 then
rs.open "select top 1 * from [system] order by addtime desc"
if not rs.eof then
itistime=rs("addtime")
if cdate(itistime)<now()-15 then isbak=1
else
isbak=1
end if
if isbak=1 then
sql="insert into [system]([name],[addtime]) values ('#"&date()&"自动备份.asp','"&now()&"')"
conn.execute(sql)
sql="delete * from [system] where cdate(addtime)<now()-60"
conn.execute(sql)
end if
rs.close
end if
'判断备份
set rs=nothing
conn.close
set conn=nothing
Dim nameindex(0)
cwjh_roominfo=split(Application("cwjh_room"),";")
for roomsn=0 to ubound(cwjh_roominfo)-1
         Application("cwjh_onlinelist"&roomsn)=nameindex
         fenroom=split(cwjh_roominfo(roomsn),"|")
         application("cwjh_chatroomname"&roomsn)=fenroom(0)
         Application("cwjh_useronlinename"&roomsn)=""
next
Dim wbq(0)
Application("cwjh_webicq")=wbq
webicqname=" "
Application("cwjh_webicqname")=webicqname
'调用备份
if isbak=1 then
        call db_bak()
end if
End sub
'自动备份数据库
Private Sub db_bak()'On Error resume Next
bak_dbpath = Server.MapPath(Application("cwjh_datapath")&"/DataBackup/#"&date()&"自动备份.asp")
SourceConn = Application("cwjh_usermdb")
DestConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & bak_dbpath
Set oJetEngine = Server.CreateObject("JRO.JetEngine")
With oJetEngine
.CompactDatabase SourceConn, DestConn
End With
End Sub
'自动备份数据库
if Application("st_gohome")="" then
Application.Lock
Application("st_gohome")="go"
Application.UnLock
call Gohome()
Response.write "<script Language=Javascript>this.location.reload()</script>"
else
Response.end
end if
%>
搜索更多相关主题的帖子: Microsoft VBScript runtime 麻烦 
2010-11-14 10:33
快速回复:Microsoft VBScript runtime error '800a0009'错误,麻烦各位帮忙看下 ...
数据加载中...
 
   



关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.017480 second(s), 9 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved