魅族pro5换电池:求救啊 ASP问题。。。。。。。。。。

来源:百度文库 编辑:高校问答 时间:2024/04/27 19:48:05
错误:ODBC 驱动程序不支持所需的属性。
代码:
<%
dim count
Nclassid=request("Nclassid")
set rs=server.createobject("adodb.recordset")
rs.open "select id,name,classid from type order by id DESC ",conn,1,1
%>
<%Dim ipagecount
Dim ipagecurrent
Dim strorderBy
Dim irecordsshown
if request.querystring("page")="" then
ipagecurrent=1
else
ipagecurrent=cint(request.querystring("page"))
end if
Set rs = Server.CreateObject("ADODB.Recordset")
rs.pagesize = 20
rs.cachesize = 20
rs.open sql,conn,1,1
ipagecount = rs.pagecount
If ipagecurrent > ipagecount Then ipagecurrent = ipagecount
If ipagecurrent < 1 Then ipagecurrent = 1
if ipagecount=0 then%>
<%else
rs.absolutepage = ipagecurrent
irecordsshown = 0
do while irecordsshown<20 and NOT rs.EOF
%>
<%for i=1 to 4%>
<%if not rs.eof then%>

<a href="display.asp?id=<%=rs("id")%>" target="_blank">

<img src="<%=rs("minipic")%>" border="0" border="0" width="200" height="200" onload="javascript:DrawImage(this);">

<%
irecordsshown = irecordsshown +1
rs.movenext
end if
next
%>

<%
loop
end if
rs.Close
set rs=nothing
%>

Set rs = Server.CreateObject("ADODB.Recordset")
rs.pagesize = 20
rs.cachesize = 20
rs.open sql,conn,1,1

换成
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
rs.pagesize = 20
rs.cachesize = 20

改改游标,看看odbc数据源的路径是否有问题

第5行,把1,1 改成3,3试试

呵呵,你用的是企业版吧,这是正常的,在.NET中,需要设置统一数据定位器,然后就可以,不知道你学SQL server了没有?