ASP连接MSSQL2005 数据库

ASP链接MSSQL2005的链接字符串如下:

Provider=SQLNCLI;Server=.\SQLEXPRESS;Database=master;Uid=xeonwell;Pwd=xxxx;

测试用例如下:(ASP链接MSSQL2005测试)

Option Explicit
Dim conn,rs,sql
Set conn = CreateObject("ADODB.Connection")
Dim strConn 'MSSQL 2005 Connection String
strConn = "Provider=SQLNCLI;Server=.\SQLEXPRESS;Database=master;Uid=xeonwell;Pwd=xxxx;"
conn.Open strConn
Set rs = conn.Execute("select * from spt_values")
Dim i,j
j = rs.fields.count-1
Response.Write("
" & rs.fields(i).name & "
" & replaceNull(rs.fields(i).value) & "
") rs.Close() Set rs = Nothing conn.Close() Set conn = Nothing Function replaceNull(str) replaceNull = str If isNull(str) OR str = "" Then replaceNull = " " End If End Function

XeonWell Studio