大家帮我看看,为什么测试不成功呢?

[nanseboy]

我用SQL server 7.0建了一个Logindb的库.里面有个login的表.我想把数据库里的数据输出到页面上.但不知道为什么总是测试不成功.是不是DSN的连接有问题呢?
<%
Dim conn , strdsn , rs
'定义用到的变量.
strdsn = "Driver={SQL Server};Server=local;UID=sa;PWD=gzjjsoft;Database=logindb"
set conn = server.createobject("adodb.connection")
conn.open strdsn
set rs = server.createobjet("adodb.recordset")
rs.Open "Select * from login"
Response.Write(rs.Recordset)
rs.close
conn.Close
%>
请高手帮忙指点一下,谢谢!!

[jxwangzhigang]

rs.Open "Select * from login"错拉！
set rs = server.createobjet("adodb.recordset")
rs.open "Select * from login"，strdsn

而且rs.Recordset也没有这样的属性把！
是不是rs.recordcount

[funboy88]

<%
Dim conn , strdsn , rs
'定义用到的变量.
strdsn = "Driver={SQL Server};Server=local;UID=sa;PWD=gzjjsoft;Database=logindb"
set conn = server.createobject("adodb.connection")
conn.open strdsn
set rs = server.createobjet("adodb.recordset")
rs.Open "Select * from login",conn,1,3
response.write rs.recordcount
rs.close
set rs=nothing
conn.Close
set conn=nothing
%>
不是你的DSN连接的问题，是你的程序的问题，错的太离谱了吧

[freezwy]

<%
Dim conn , strdsn , rs
'定义用到的变量.
strdsn = "Driver={SQL Server};Server=local;UID=sa;PWD=gzjjsoft;Database=logindb"
set conn = server.createobject("adodb.connection")
conn.open strdsn
set rs = server.createobjet("adodb.recordset")
rs.Open "Select * from login",conn,1,1
if rs.eof and rs.bof then
response.write "no"
else
response.write rs("username")'就是字段名
end if
rs.close
conn.Close
%>

[nanseboy]

我是刚开始学ASP.呵.有些错得比较菜的地方别见怪.