问题：请高手帮我解释一下是什么错了!<％set conn=Server.CreateObject(ADODB.Connection)conn.connectionstring=driver={SQL Server};Server=CHWAIN\WAIN;UID=sa;PWD=sa123;database=Talkingconn.openresponse.Write conn.state:& conn.state & vbCRset RS=Server.CreateObject(ADODB.Recordset)SQLString=select * from Friendsset RS=conn.Execute(SQLString)rs.open rs.addnewrs(num)=10rs(name)=Chenrs(sex)=男rs(birthday)=1986-05-21rs(age)=23rs.updateRS.movefirstresponse.Write(<table>)do while not RS.eofresponse.Write(<tr>)for i= 0 to RS.fields.count-1response.Write(<td>&rs(i)&</td>)nextresponse.Write</tr>RS.movenextloopresponse.Write(</table>)rs.closers=nothingconn.close％>错误类型：ADODB.Recordset (0x800A0E79)对象打开时，不允许操作。/Talking/connection.asp, 第 18 行
改成这样试试，因为用conn.Execute(SQLString) 时，数据库是以只读方式打开，而且游标不能往回移动，只能向后移动，改用rs.open SQLString,conn,1,3
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.connectionstring="driver={SQL Server};Server=CHWAIN\WAIN;UID=sa;PWD=sa123;database=Talking"
conn.open
response.Write "conn.state:"& conn.state & vbCR
set RS=Server.CreateObject("ADODB.Recordset")
SQLString="select * from Friends"
rs.open SQLString,conn,1,3
rs.addnew
rs("num")=10
rs("name")="Chen"
rs("sex")="男"
rs("birthday")="1986-05-21"
rs("age")=23
rs.update
RS.movefirst
response.Write("<table>")
do while not RS.eof
response.Write("<tr>")
for i= 0 to RS.fields.count-1
response.Write("<td>"&rs(i)&"</td>")
next
response.Write"</tr>"
RS.movenext
loop
response.Write("</table>")
rs.close
rs=nothing
conn.close
%>
如果你对请高手帮我解释一下是什么错了!<％set conn=Server.CreateObject(ADODB.Connection)conn.connectionstring=driver={SQL Server};Server=CHWAIN\WAIN;UID=sa;PWD=sa123;database=Talkingconn.openresponse.Write conn.state:& conn.state & vbCRset RS=Server.CreateObject(ADODB.Recordset)SQLString=select * from Friendsset RS=conn.Execute(SQLString)rs.open rs.addnewrs(num)=10rs(name)=Chenrs(sex)=男rs(birthday)=1986-05-21rs(age)=23rs.updateRS.movefirstresponse.Write(<table>)do while not RS.eofresponse.Write(<tr>)for i= 0 to RS.fields.count-1response.Write(<td>&rs(i)&</td>)nextresponse.Write</tr>RS.movenextloopresponse.Write(</table>)rs.closers=nothingconn.close％>错误类型：ADODB.Recordset (0x800A0E79)对象打开时，不允许操作。/Talking/connection.asp, 第 18 行这个问题有好的意见或
建议，请留言
|
您当前的位置：
百科371 → 电脑/网络 → 网站推荐 → 电脑/网络内容
退出登录 
减小字体
增大字体