Forum Moderators: open
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E31)
[Microsoft][ODBC SQL Server Driver]Timeout expired
/anews/5.asp, line 19
My codes are
<%
Server.ScriptTimeOut = 320
%>
<!--#include file="connection.asp"-->
<!--#include file="adovbs.inc"-->
<html>
<head>
<title>Untitled</title>
</head>
<body>
<%
Dim s
Dim rs,i
set rs = Server.CreateObject("ADODB.RecordSet")
SQL = "SELECT NEWS_ID,CITY,HEADLINE,DESCRIPTION FROM INT_NEWS_POOL ORDER BY NEWS_ID DESC"
rs.open SQL,Con
rs.pagesize = 5
rs.MaxRecords = 2000
for i=1 to rs.pagesize
If rs.eof Then exit for
%>
<table width="100%" border="0" cellspacing="2" cellpadding="4" align="center">
<tr>
<td width="25%" bordercolor="#FFFFFF" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF" border="0" cellspacing="2" cellpadding="0">
<div align="center"><a href="detay.asp?id=<%=rs("NEWS_ID")%>"></a></div>
</td>
<td width="65%" align="left"><strong><font size="2" face="Tahoma"><%= rs("CITY")%>
<%=rs("HEADLINE")%></font></strong><br><font face="Verdana" size="2"> <%=rs("DESCRIPTION")%></font></td>
<td width=""><p><font face="Verdana" size="1" color="#808080"><%=rs("FILE_DATE")%><br>
<a href="detay.asp?id=<%=rs("NEWS_ID")%>"><font face="Verdana" size="2">metin</font></a>
</td>
</tr>
<hr>
</table>
<%
rs.MoveNext
Next
%>
</body>
</html>
Server.ScriptTimeOut = 640
?
Make sure you have where clauses :)
Elky
Try adding primary keys to your table. It worked for me.
makeupalley had a good point by narrowing down the criteria for your query.
Also, do you have any indexes on the table other than the primary key?
Dave
