对象名 'news' 无效,小问题,谢谢哪位帮忙解决下.

<%  
set strs=server.createobject("adodb.recordset")  
stsql="select id,Title,time from news order by time desc"  
strs.open stsql, conn, 1, 1  
if not strs.eof then  
strs.PageSize =15 '每页记录条数  
result_num=strs.RecordCount '记录总数  
maxpage=strs.PageCount  
page=request("page")  
if Not IsNumeric(page) or page="" then  
page=1  
else  
page=cint(page)  
end if  
if page<1 then  
page=1  
elseif page>maxpage then  
page=maxpage  
end if  
strs.AbsolutePage=Page  
else  
result_num=0  
maxpage=0  
page=0  
end if  
if not strs.eof then  
for i=1 to strs.PageSize  
  
Response.Write ("<table width=248 border=0 cellspacing=0 cellpadding=0>")  
Response.Write ("<tr>")  
Response.Write ("<td width=15 height=20><img src=images/doc.gif width=10 height=12 align=absmiddle></td>")  
Response.Write ("<td width=369><a href=News/News_"&strs("id")&".html>"&strs("title")&"</a></td>")  
Response.Write ("</tr>")  
Response.Write ("</table>")  
strs.movenext  
if strs.EOF then Exit For  
next  
end if  
strs.close  
set strs=nothing  
%> 

错误提示:

<p>Microsoft OLE DB Provider for SQL Server</font> <font face="宋体" size=2>错误 '80040e37'</font>
<p>
<font face="宋体" size=2>对象名 'news' 无效。</font>

确认表news存在吗? 把SQL语句在数据库里运行看看是否成功。

select id,Title,time from news order by time desc

SQL有问题