update 什么问题?~~~~~~~~~~~~~~~~~~~~~~~~~
<%
'------- 写入IP.MDB 数据文件
db= "D:\web\barcodeprinter\backup\ip.mdb "
conn= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & db
set rs = server.createobject( "adodb.recordset ")
sql= "update ipinfo set [connect]= 'open ' where ip= '10.97.1.35 ' "
conn.Execute(sql)
rs.update
set rs=nothing
'------- 写入结束
%>
显示:
Microsoft VBScript 运行时错误 错误 '800a01a8 '
缺少对象: 'conn '
/barcodeprinter/backup/ip.asp,行 7
[解决办法]
<%
'------- 写入IP.MDB 数据文件
db= "D:\web\barcodeprinter\backup\ip.mdb "
set conn = server.createobject( "adodb.connection ")
strconn= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & db
conn.open strconn
set rs = server.createobject( "adodb.recordset ")
sql= "update ipinfo set [connect]= 'open ' where ip= '10.97.1.35 ' "
conn.Execute(sql)
set rs=nothing
'------- 写入结束
%>
[解决办法]
把rs.update去掉看看