ASP连接SQLserver数据库怎么连？

[daidai0]

要从SQLserver数据库中读取一个表中的一个字段，给串代码，谢谢谢谢

[cpp2017]

Dim conn,rs,strSQL
strSQL = " select Name form table1"
set conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=sqloledb;Data Source=localhost ;Initial Catalog=databasename;User Id=aaa; Password=***"
set rs = Server.CreateObject("ADODB.RECORDSET")
rs.open strSQL,Conn,1,1
Response.write(rs("name").value)

[cuipeng99]

strconn = "Driver={SQL erver};Description=sqldemo;SERVER=127.0.0.1;UID=LoginID;&_
PWD=Password;DATABASE=Database_Name

set conn = server.createobject("adodb.connection")

conn.open strconn