sql server连接菜鸟问题

[pdysuny]

sql server中有登陆id和密码,有数据库id和密码=soho,我有数据库job,如何连接它.是用登陆id还是数据库id啊?

这样连接不上呢?

<%
option explicit
db="mmjob"
Pass_word="soho"
User_ID="sa"
Data_Source="(local)"
Set conn = Server.CreateObject("ADODB.Connection")
connStr="Provider=SQLOLEDB.1;Password='"&pass_word&"';Persist Security Info=True;User ID='"&User_ID&"';Initial Catalog='"&db&"';Data Source='"&Data_Source&"'"
conn.Open connstr

%>

[pdysuny]

???

[gyljfang]

Dim SqlDatabaseName,SqlPassword,SqlUsername,SqlLocalName
SqlDatabaseName = "mmtop"
SqlPassword = "(你的数据库用户密码)"
SqlUsername = "sa"(用户名)
SqlLocalName = "localhost"
ConnStr = "Provider = Sqloledb; User ID = " & SqlUsername & "; Password = " & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source = " & SqlLocalName & ";"
Set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionTimeout = 7
conn.open ConnStr

[pdysuny]

数据库是mmjob