金时利文件夹:Microsoft JET Database Engine (0x80040E14)是什么错误
来源:百度文库 编辑:高校问答 时间:2024/04/29 07:15:51
程序代码如下:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/conn.asp" -->
<%
' *** Restrict Access To Page: Grant or deny access to this page
MM_authorizedUsers="superadmin"
MM_authFailedURL="login.asp"
MM_grantAccess=false
If Session("MM_Username") <> "" Then
If (true Or CStr(Session("MM_UserAuthorization"))="") Or _
(InStr(1,MM_authorizedUsers,Session("MM_UserAuthorization"))>=1) Then
MM_grantAccess = true
End If
End If
If Not MM_grantAccess Then
MM_qsChar = "?"
If (InStr(1,MM_authFailedURL,"?") >= 1) Then MM_qsChar = "&"
MM_referrer = Request.ServerVariables("URL")
if (Len(Request.QueryString()) > 0) Then MM_referrer = MM_referrer & "?" & Request.QueryString()
MM_authFailedURL = MM_authFailedURL & MM_qsChar & "accessdenied=" & Server.URLEncode(MM_referrer)
Response.Redirect(MM_authFailedURL)
End If
%>
<%
if(Request.QueryString("id") <> "") then cmd__did = Request.QueryString("id")
%>
<%
set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = MM_conn_STRING
cmd.CommandText = "DELETE FROM main WHERE ID = " + Replace(cmd__did, "'", "''") + ""
cmd.CommandType = 1
cmd.CommandTimeout = 0
cmd.Prepared = true
cmd.Execute()
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>留言删除成功</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="css.css" rel="stylesheet" type="text/css">
<meta http-equiv="refresh" content="3;URL=admin.asp">
</head>
<body>
<table width="650" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000" class="thin">
<tr>
<td height="35" align="center" back ground="images/topbg.gif">留言板</td>
</tr>
<tr>
<td height="20" align="right" back ground="images/bmbg.gif">『<a href="insert.asp">留言</a>』 『<a href="index.asp">查看</a>』 『<a href="login.asp">管理</a>』</td>
</tr>
<tr>
<td align="center">记录删除成功,3秒后返回<a href="admin.asp">管理页面</a></td>
</tr>
<tr>
<td height="20" align="center" back ground="images/bbg.gif">版权所有人</td>
</tr>
</table>
</body>
</html>
出现的问题:
无法显示网页
试图访问的网页出现问题,无法显示。
--------------------------------------------------------------------------------
请尝试执行下列操作:
单击刷新按钮,或稍后重试。
打开 127.0.0.1 主页,然后查找与所需信息相关的链接。
HTTP 错误 500.100 - 内部服务器错误 - ASP 错误
Internet 信息服务
--------------------------------------------------------------------------------
技术信息(用于支持人员)
错误类型:
Microsoft JET Database Engine (0x80040E14)
语法错误 (操作符丢失) 在查询表达式 'ID=' 中。
/guestbook/login.asp, 第 16 行
浏览器类型:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322; 56flvplayer 1.0)
网页:
GET /guestbook/login.asp
时间:
2006年5月23日, 9:59:48
详细信息:
Microsoft 支持
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/conn.asp" -->
<%
' *** Restrict Access To Page: Grant or deny access to this page
MM_authorizedUsers="superadmin"
MM_authFailedURL="login.asp"
MM_grantAccess=false
If Session("MM_Username") <> "" Then
If (true Or CStr(Session("MM_UserAuthorization"))="") Or _
(InStr(1,MM_authorizedUsers,Session("MM_UserAuthorization"))>=1) Then
MM_grantAccess = true
End If
End If
If Not MM_grantAccess Then
MM_qsChar = "?"
If (InStr(1,MM_authFailedURL,"?") >= 1) Then MM_qsChar = "&"
MM_referrer = Request.ServerVariables("URL")
if (Len(Request.QueryString()) > 0) Then MM_referrer = MM_referrer & "?" & Request.QueryString()
MM_authFailedURL = MM_authFailedURL & MM_qsChar & "accessdenied=" & Server.URLEncode(MM_referrer)
Response.Redirect(MM_authFailedURL)
End If
%>
<%
if(Request.QueryString("id") <> "") then cmd__did = Request.QueryString("id")
%>
<%
set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = MM_conn_STRING
cmd.CommandText = "DELETE FROM main WHERE ID = " + Replace(cmd__did, "'", "''") + ""
cmd.CommandType = 1
cmd.CommandTimeout = 0
cmd.Prepared = true
cmd.Execute()
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>留言删除成功</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="css.css" rel="stylesheet" type="text/css">
<meta http-equiv="refresh" content="3;URL=admin.asp">
</head>
<body>
<table width="650" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000" class="thin">
<tr>
<td height="35" align="center" back ground="images/topbg.gif">留言板</td>
</tr>
<tr>
<td height="20" align="right" back ground="images/bmbg.gif">『<a href="insert.asp">留言</a>』 『<a href="index.asp">查看</a>』 『<a href="login.asp">管理</a>』</td>
</tr>
<tr>
<td align="center">记录删除成功,3秒后返回<a href="admin.asp">管理页面</a></td>
</tr>
<tr>
<td height="20" align="center" back ground="images/bbg.gif">版权所有人</td>
</tr>
</table>
</body>
</html>
出现的问题:
无法显示网页
试图访问的网页出现问题,无法显示。
--------------------------------------------------------------------------------
请尝试执行下列操作:
单击刷新按钮,或稍后重试。
打开 127.0.0.1 主页,然后查找与所需信息相关的链接。
HTTP 错误 500.100 - 内部服务器错误 - ASP 错误
Internet 信息服务
--------------------------------------------------------------------------------
技术信息(用于支持人员)
错误类型:
Microsoft JET Database Engine (0x80040E14)
语法错误 (操作符丢失) 在查询表达式 'ID=' 中。
/guestbook/login.asp, 第 16 行
浏览器类型:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322; 56flvplayer 1.0)
网页:
GET /guestbook/login.asp
时间:
2006年5月23日, 9:59:48
详细信息:
Microsoft 支持
<%
if(Request.QueryString("id") <> "") then c
md__did = Request.QueryString("id")
%>
<%
set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = MM_conn_STRING
cmd.CommandText = "DELETE FROM main WHERE ID = " + Replace(cmd__did, "'", "''") + ""
cmd.CommandType = 1
cmd.CommandTimeout = 0
cmd.Prepared = true
cmd.Execute()
else
response.write "对不起ID值取不到"
response.end
end if
%>
变量的值为空(或缺少关键字) ,请仔细查看源代码
"DELETE FROM main WHERE ID = " + Replace(cmd__did, "'", "''") + ""
中,cmd__did中无内容,请核查
Microsoft JET Database Engine是什么?
Microsoft JET Database Engine是什么?
microsoft jet 4.0 service pack 8是什么?
Microsoft .Jet.OLEDB.4.0怎么下载安装?
Microsoft JET Database Engine (0x80004005)
Microsoft Jet 数据库引擎打不开文件 怎么办?
Microsoft JET Database Engine (0x80004005)
Microsoft JET Database Engine (0x80040E10)
Microsoft JET Database Engine (0x80040E14)
Microsoft JET Database Engine (0x80040E4D)