经典ASP sql服务器“不允许操作"；错误 [英] Classic ASP sql server "operation is not allowed" error
问题描述
我遇到错误:
Request object error 'ASP 0104 : 80004005'
Operation not Allowed
/post.asp, line 3
尝试写入我的数据库后出现此错误.我添加的代码是
This error came after attempting to write to my database. The code I added was
jquery stuff{
ar2 = useless2.split("Summary");
ar = ar2[0];
re = new RegExp("\n", "g");
useless = ar.replace(re, "<br>");
re = new RegExp('"', "g");
useless = ar.replace(re, '""');
used = useless;
}
html stuff{
<input type="hidden" name="vDescription_' + c + '" value="' + used + '">
}
(是的，我知道used = useless是没用的)
(Yes I know used=useless is useless)
说明的示例:
<input type="hidden" name="vDescription_323" value="
0:07 Discussion
1:06 Introduction and Motivation
2:24 Support Vector Machines
6:59 The Financial Kernel (FK)
8:28 Kernel Methods
10:10 Example
10:14 Data Selection
10:34 Preprocessing
10:57 Testing
">
这是从检查元素中拉出来的.我不完全确定为什么它会显示新行而不是
代码，这可能是导致错误的原因?
This is pulled from inspecting the elements. I'm not entirely sure why it shows me new lines instead of the
code, which may be contributing to the error?
ASP代码:
<!--#include file="connv.inc"-->
<%
n=Request.form("total")
response.write(n)
for x = 0 to n-1
ttitle=Request.form("title_"&x)
title=Replace(ttitle, "'", "''")
id=Request.form("id_"&x)
views=Request.form("vViews_"&x)
likes=Request.form("vLikes_"&x)
description=Request.form("vDescription_"&x)
sql="if NOT exists (select * from tbl_videos where videoId = '"&id&"') INSERT INTO tbl_videos(videoTitle, videoId, videoLikes, videoViews, videoDescription, swamCompatible) values ('"&title&"', '"&id&"', '"&likes&"', '"&views&"', '"&description&"', '0')"
connv.execute(sql)
response.write(sql&"<br>")
next
%>
<html>
<head>
<title> Updating Tables </title>
</head>
<body>
</body>
</html>
<!--#include file="closeEmv.inc"-->
推荐答案
当发布的数据大小超过ASP最大实体请求正文限制"时，会出现此错误.
You can get this error when the posted data size exceeds the ASP "Maximum Entity Requesting Body Limit".
来自 Microsoft :
如果存在Content-Length标头，并且Content-Length标头指定的数据量大于IIS元数据库中AspMaxRequestEntityAllowed属性的值，则会发生此问题. AspMaxRequestEntityAllowed属性的默认值为204,800字节.
This issue occurs if a Content-Length header is present and if the Content-Length header specifies an amount of data that is larger than the value of the AspMaxRequestEntityAllowed property in the IIS metabase. The default value for the AspMaxRequestEntityAllowed property is 204,800 bytes.
这篇关于经典ASP sql服务器“不允许操作"；错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
