asp连接sql server 数据库的问题?
<%
dim conn
dim connstr
on error resume next
connstr="uid=sa;pwd=zgc;database=film;DRIVER={sql server}"
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr
%>
<%
dim rs,total,i
i=0
set rs=server.createobject("adodb.recordset")
sql="select count(*) from film_detail "
rs.open sql,conn,1,1
while not rs.eof and i<>10
i=i+1
response.write i
response.write rs("filmtype")
rs.movenext
wend
rs.close
%>
数据库连接不报错,但我不能重数据库中取得数据,同时我运行该程序,好象做了个死循环,i,写出n个i的值