建议这样写用OLE DB FOR SQL SERVER提供程序:
<%
dim conn
set conn=server.createobject("adodb.connection")
conn.connectionstring="Provider=SQLOLEDB.1;Data Source=服务器;User ID=用户名;Password= 密码;Initial Catalog=数据库"
conn.open
%>
set conn=server.createobject("adodb.connection")
sql="driver={sql server};server="servername";database="table";uid=;pwd="
set rs=conn.execute(sql)
'''''联结数据库