如何链接到服务器

我在学习ASP+SQL

 请问:如何链接到SQL服务器呢?

ConnStr="driver={SQL Server};server="&SqlLocalName&";uid="&SqlUsername&";pwd="&SqlPassword&";database="&SqlDatabaseName&";"

 on error resume next
Set conn = Server.CreateObject("ADODB.Connection")
conn.commandtimeout=20
conn.open ConnStr

If Err.number>0 Then
err.Clear
Set Conn = Nothing
Response.Write "<br><br><br><br><br><br><br><div align='center'>数据库连接出错!请检查连接数据库的参数及字符串设置是否正确！</div>"
Response.End


End If

<% 
Dim Conn, StrConn 
Set Conn = Server.CreateObject( "ADODB.Connection ") 
strconn= "Driver={SQL Server};Server=服务器名;uid=sa;pwd=密码;Database=数据库名 " 
Cnn.Open StrConn 

%>