asp 连接sql server 32分

[da21]

<%@ language = "VBscript" %>
<%
var Conn = Server.CreateObject("ADODB.Connection");
Conn.Open("driver={SQL Server};database=pubs;server=LEI-0DXYU7DZ7YP;uid=sa;pwd=");
var rs = Conn.Execute("Select * From Titles");
for (i = 0; i < rs.Fields.Count; i++)
{
Response.Write(rs(i).Name + "<br>");
}
%>
请问为何我连接不了,我记得以前是可以的,只是重装SQL Server后没设密码,反而连不上了
LEI-0DXYU7DZ7YP 服务器名没错
Select * From Titles 中的Titles表也有
是不是 pwd= 这里有问题?

[GX198302]

connectionString="Provider=SQLOLEDB.1;Data Source="+serverName+";Integrated Security=SSPI;Initial Catalog="+databaseName;

[GX198302]

下次记得设密码:)

[风流才子]

Dim Conn,ConnStr
Set Conn = Server.CreateObject("ADODB.Connection")
ConnStr = "PROVIDER=SQLOLEDB;DATA SOURCE=SQL服务器名称或IP地址;UID=sa;PWD=数据库密码;DATABASE=数据库名称"
Conn.Open ConnStr