用 asp怎么连到sql sever200上

[duzhenguo]

在asp中怎么连到数据库中，
<%
strConnString ="Provider=SQLOLEDB.1;Password=;" & _
"Persist Security Info=True;User ID=sa;" & _
"Initial Catalog=practice;" & _
"Data Source=LocalServer;Connect Timeout=15"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open strConnString
Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.open "select * from student",objConn,3,3
%>
Initial Catalog 参数用来表示什么，我的服务管理器中 服务器 是ronaldo 服务是 SQL Sever
数据库名是practice 为什么总是连不上
在sql sever2000的企业管理器里sql sever组里只有ronaldo(windows nt) 不知是什么问题，敬请大家指教

[swich]

用这种方式试试
<%
set cn=server.CreateObject("adodb.connection")
cn.ConnectionString="driver={SQL SERVER}; server=servername; database=dbname; uid=sa; pwd=12345;"
cn.open
Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.open "select * from student",cn,3,3
%>

[xieyj]

在原来的方式上做个异常处理：
<%
on error resume next
strConnString ="Provider=SQLOLEDB.1;Password=;" & _
"Persist Security Info=True;User ID=sa;" & _
"Initial Catalog=practice;" & _
"Data Source=LocalServer;Connect Timeout=15"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open strConnString
if err.number <> 0 then
response.write "err: " & err.description
end if
Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.open "select * from student",objConn,3,3
%>