星期五, 2月 17, 2006

[asp]dsn to access mdb


<%
set dbconnection=server.createobject("adodb.connection")
dbconnection.open "kpdb"
set rs=server.createobject("adodb.recordset")
rs.open "schoolnew",dbconnection
%>

<%
rs.movefirst
while not rs.eof
  response.write rs("title")
  rs.movenext
wend
rs.close dbconnection.close
%>