大家帮我看一下这个CONN怎么写

qzhengyi · 发表于 2009-5-26 14:07:07

从网上下了个甘肃家装网的程序，可是CONN怎么写才能链到数据库上，大家能不能帮我用中文给写一下
<%
Dim SqlDatabaseName,SqlPassword,SqlUsername,SqlLocalName
  Dim ConnStr
  On Error Resume Next
  Set conn = Server.CreateObject("ADODB.Connection")
  SqlDatabaseName = "gsjzw.com"
  SqlPassword = "sa"
  SqlUsername = "sa"
  SqlLocalName = "127.0.0.1"
  ConnStr = "Provider = Sqloledb; User ID = " & SqlUsername & "; Password = " & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source = "203.171.230.203";"
  conn.Open connstr
  If Err Then
  err.Clear
  Set Conn = Nothing
  Response.Write "数据库连接出错，请检查连接字串。"'注释，需要把这几个字翻译成英文。
  Response.End
  End If
%>