A lot of data

[shahid]

hi i m using ms access on web for my site

there is a lot of data when i click to show all list.

it's start the process...

then the script time out error comes before completing the
list .....


i alsow write server.scripttimeout=900

but still this.....

can any one how i solve this....

thanks

[Anglo Saxon]

You need to set the Command.CommandTimeout property here as well as the Server.Scripttimeout . The reason for this is that with the CommandTimeout, you are indicating how long to wait for the Command (your sql query) to execute, while with the Server.Scripttimeout you are indicating how long to wait for the page code to complete execution.

If you are not explicitly using a Command object then you can still set the CommandTimeout using the connection object :

Set con = CreateObject("adodb.connection")
con.CommandTimeout = 300
con.Open "pubs", "sa", ""

You must set the property before you open the connection and also take note that even if the user gets tired of waiting and tries to cancel the query by navigating to another page or closing their browser then the query doesnt stop running until it has either finished or it times out, this can be a big strain on the server if you set the timeout too long.

--
Anglo Saxon

[shahid]

but i m using rs to open a recordset and it's done one time

my code is

rs.open "select * from pubs order by pid",myconn

do while not rs.eof
response.write rs("pubid") & "==" & rs("pubname") & "<BR>"
rs.movenext
loop

now wot u say...

[Anglo Saxon]

Have you actually tried what I suggested?

The CommandTimeout on a Connection applies to the Connection.Execute & Recordset.Open methods when you are not explicitly declaring a Command object as the source property. In other words setting the CommandTimeout on the connection object in your case is relevant because you are using the Recordset.Open method with a Connection as the source property.

Understand?

--
Anglo Saxon