在线急等求助 Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'

jkxuser 2007-05-12 10:02:16

以下是修改页面代码:
<html><body>
<%
str=request("nodeid")
objectsubtype=request("objectsubtype")
caption=request("caption")
dns=request("dns")
community=request("community")
rediscoveryinterval=request("rediscoveryinterval")
pollinterval=request("pollinterval")
set conn=server.createobject("adodb.connection")
conn.open "driver={sql server};server=127.0.0.1;uid=sa;password=haha12;"&_
"database=NetPerfMon"
set cmd=server.createobject("adodb.command")

cmd.activeconnection=conn
sql="update nodes set objectsubtype=" & objectsubtype & ",caption=" & caption & ",dns=" & dns & ",community=" & community & ",rediscoveryinterval=" & rediscoveryinterval & ",pollinterval=" &_ pollinterval & " where nodeid=" & str

response.write sql '可输出

cmd.commandtext=sql

cmd.execute () '行22

response.redirect("pagev6.asp")
%>
</body></html>

执行后的页面提示如下:

update nodes set objectsubtype=SNMP,caption=0.47.1.10.in-addr.arpa,dns=0.47.1.10.in-addr.arpa,community=public,rediscoveryinterval=30,pollinterval=120 where nodeid=8
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]第 1 行: '.1' 附近有语法错误。

/netperfmon/do_mdysmt.asp，行 22

在网上查了一下午资料,也在论坛看了7个相关信息,都没有解决这个问题,不知道是怎么回事.

请求各位朋友帮忙解决下,谢谢

...全文