ASP怎么使用ADO-ODBC链接SQL sever数据库

November 16, 2019

631views

62 words

方法一：

<html>
<head>
<title></title>
</head>
<body>
<%
 Set Conn=Server.CreateObject("ADODB.Connection")
 
 Conn.Open "Provider = Sqloledb; User ID = sa; Password = 123; Initial Catalog = factory; Data Source = localhost,1433;"

 set rs = Server.CreateObject("ADODB.recordset")
rs.Open "SELECT * FROM worker", conn
   
 do until rs.EOF
  for each x in rs.Fields
    Response.Write(x.name)
    Response.Write(" = ")
    Response.Write(x.value & "<br />") 
  next
  Response.Write("<br />")
  rs.MoveNext
loop

rs.close
conn.close
%>
</body>
</html>

方法二：

<html>
<head>
<title></title>
</head>
<body>
<%
 Set Conn=Server.CreateObject("ADODB.Connection")
 
Conn.Open "Driver=SQL Server;Database=factory;Server=localhost,1433;UID=sa;PWD=123;"

 set rs = Server.CreateObject("ADODB.recordset")
rs.Open "SELECT * FROM worker", conn
   
 do until rs.EOF
  for each x in rs.Fields
    Response.Write(x.name)
    Response.Write(" = ")
    Response.Write(x.value & "<br />") 
  next
  Response.Write("<br />")
  rs.MoveNext
loop

rs.close
conn.close
%>
</body>
</html>

版权属于：本文为原创文章，版权归A'kun所有，转载请注明出处！
本文链接：https://www.akunblog.com/archives/242.html
转载时须注明出处及本声明