<%
set cn=server.createobject("adodb.connection")
cn.provider="sqloledb"
cn.open "driver={sql server};server=(local);uid=sa;pwd=;
database=your database"
set rs=……
%>
<%
set cn=server.createobject("adodb.connection")
cn.provider="sqloledb"
cn.open "driver={sql server};server=(local);uid=sa;pwd=;
database=your database"
set rs=……
%>