￥￥￥￥￥￥￥￥￥￥￥￥高手请进，这个错误为什么有时候出现，有时候不出现呢？￥￥￥￥￥￥￥￥￥

jnhfly 2004-11-20 11:38:48

在我向数据库里修改的时候有时候会出现
Microsoft VBScript 编译器错误错误 '800a03f6'

缺少 'End'

/iisHelp/common/500-100.asp，行242

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

[Microsoft][ODBC SQL Server Driver][SQL Server]将截断字符串或二进制数据。

/xin/admin/msortmodifyok.asp，行11

的错误，有时候却运行的很正常，是为什么呢？

我怀疑是ubb代码的事，高手帮忙啊，

...全文

104 16 打赏收藏转发到动态举报

写回复

用AI写文章

16 条回复

切换为时间正序

请发表友善的回复…

发表回复

applezhao 2004-11-20

打赏
举报

可能是网页中垃圾代码太多了

jnhfly 2004-11-20

打赏
举报

我添加的是 http://www.minai-autoservice.com/description.asp?vtid=0015005
表中的所有数据，我想知道是TEXT大，还是Ntext大，我用ntext对了

applezhao 2004-11-20

打赏
举报

可能是太大了

bolm 2004-11-20

打赏
举报

设置成TEXT呢？
可以了吗？

bolm 2004-11-20

打赏
举报

肯定还是超出了8000个字符才这样的

是是非非 2004-11-20

打赏
举报

把varchar换成text
varchar(8000)不是最大的

超级大笨狼 2004-11-20

打赏
举报

Typically, this is caused by trying to insert too many characters into a defined column. For example:

CREATE TABLE #foo (bar CHAR(5))
INSERT #foo(bar) VALUES('yoohoo')

A couple of easy fixes include:

using client-side methods (e.g. MAXLENGTH or JavaScript) to prevent such data from being submitted;
adjusting the column definition(s) to accommodate for likely data lengths;
adjusting the incoming data to fit the column definition, e.g.:

<%
bar = replace(left(request.form("bar"),5),"'","''")
sql = "INSERT #foo(bar) VALUES('" & bar & "')"
' ...
%>

There may be another reason for this symptom, if you are seeing this error from ASP but do not see it in native tools; for example, Query Analyzer. You can alleviate this by making SET database options consistent -- see KB #255765 for more information.

--------------------------------------------------------------------------------

Microsoft OLE DB Provider for ODBC Drivers error '80040e57'
[Microsoft][ODBC Microsoft Access Driver]Numeric value out of range (null)

Check that you are inserting valid numbers into numeric columns. These should not contain any non-numeric characters, and should not be enclosed in quotes.

jnhfly 2004-11-20