Timeout problem

Hi !

We have an ASP-application that uses storedprocedures to talk to an
SQL-Server database.

The problem is that we get an error that says "the page can not be found"

This error appears when the search in the database takes time and results in
many rows(500 - 1500)

I can see in the database that the storedprocedures starts but it never
finishes.

When I run the storedprocedure directly against SQL-server I get the result
but it takes time(30 to 50 seconds)



Is there a connection timeout that I can change or can it be something else?

The server is a windows 2000 server and SQL 2000, it runs on dell poweredge
2500 , 1 cpu and 512 mb RAM.

Regards Jan Rockstedt

Gilgamesh
Wed Feb 11 16:20:41 CST 2004

Extend the command time out for ADO.
G.

"Janne" <_NO_SPAM_@telia.com> wrote in message
news:O87lkqI8DHA.1052@TK2MSFTNGP12.phx.gbl...
> Hi !
>
> We have an ASP-application that uses storedprocedures to talk to an
> SQL-Server database.
>
> The problem is that we get an error that says "the page can not be found"
>
> This error appears when the search in the database takes time and results
in
> many rows(500 - 1500)
>
> I can see in the database that the storedprocedures starts but it never
> finishes.
>
> When I run the storedprocedure directly against SQL-server I get the
result
> but it takes time(30 to 50 seconds)
>
>
>
> Is there a connection timeout that I can change or can it be something
else?
>
> The server is a windows 2000 server and SQL 2000, it runs on dell
poweredge
> 2500 , 1 cpu and 512 mb RAM.
>
> Regards Jan Rockstedt
>
>