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) & " |