conn_sqlserver.asp

来自「怎样用ASP连接数据库系统」· ASP 代码 · 共 19 行

<%
        dim sql,rs,conn

	set conn=server.createobject("ADODB.Connection")  
	'conn.open "Driver={SQL Server};Server=(local);Database=LearnSQL;Uid=sa;Pwd="    '直接访问数据库(即直接提供DSN信息)
	conn.open "DSN=learnSQL;UID=sa;PWd="     '通过ODBC数据源访问数据库(即先在系统设置好DSN信息)

	set rs=server.createobject("ADODB.Recordset")
        sql="select * from myTable"
        rs.open sql,conn,1,3
        do while not rs.eof
        response.write rs("姓名")&"<br>"
        rs.movenext
        loop
	set rs=nothing
	conn.close
	set conn=nothing
%>