Question

急~ 求助 asp 对象关闭时，不允许操作。

<% dim strsql,DBPath,connstr
dbpath ="data/cbc.mdb"
connstr= "provider=Microsoft.jet.oledb.4.0;Data Source ="&server.mappath("dbpath")
set rs = server.createObject("ADODB.Connection")
strsql="select ProductName from Products"
rs.open strsql,connstr,1,2

do while not rs.eof
response.write rs("productName")
response.write"<br>"
rs.movenext
loop
%>

就是这段代码运行的时候出现对象关闭，不允许操作怎么回事？

Answer 1

<% dim strsql,DBPath,connstr
dbpath ="data/cbc.mdb"
connstr= "provider=Microsoft.jet.oledb.4.0;Data Source ="&server.mappath("dbpath")
set conn.= server.createObject("ADODB.Connection")
conn.open connstr
strsql="select ProductName from Products"
Set rs= Server.CreateObject("ADODB.Recordset")
rs.open strsql,conn,1,1
do while not rs.eof
response.write rs("productName")
response.write"<br>"
rs.movenext
loop
%>