<%
set conn=server.createobject("adodb.connection")
conn.open "driver={sql server};server=ServerName;pwd=123456;uid=sa;database=NorthWind"
set rs=server.createobject("adodb.recordset")
sql = "SELECT * FROM Orders where orderid='10248'"
rs.open sql,conn,adopenstatic
do while not rs.eof
response.write rs(0) & "<br>"
rs.MoveNext
loop
rs.close
set rs = nothing
conn.close
set conn = nothing
%>