asp连接sql server的详细步骤可以列一下吗?

ASP与SQL Server数据库连接：
<%
dim conn
set conn=server.createobject("ADODB.connection")
conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=SQL服务器名称或IP地址;UID=sa;PWD=数据库密码;DATABASE=数据库名称"
%>

dim con
dim sql
sql="select * from 表名"
set con=server.createobject("adodb.connection")
con.connectionstring="provider=sqloledb;data source=127.0.0.1;uid=sa;pwd=;database=你的数据库名"
con.open
set rs=server.createobject("adodb.recordset")
rs.open sql,con,2,3

dim conn
set conn=server.createobject("adodb.connection")
conn.connectionstring="dirver={sqlserver};server=127.0.0.1;uid=sa;pwd=sa;database=book"
conn.open