asp中连接sql2000

Question

关注asp和sql server 连接开发

Answer 1

2.ASP<%
set conn=server.createobject("adodb.connection")
    conn.open "driver={sql server};server=ServerName;pwd=123456;uid=sa;database=NorthWind"
set rs=server.createobject("adodb.recordset")sql = "SELECT * FROM Orders where orderid='10248'"
    rs.open sql,conn,adopenstaticdo while not rs.eof
   response.write rs(0) & "<br>"
   rs.MoveNext
looprs.close
set rs = nothing
conn.close
set conn = nothing
%>3. SQL 服务器必须是混合模式