Connection time out

[Jarrad]

Running an ASP.net page, when put a large query through
the server, the I get an error connection times out.

How can I can I avoid this problem?

For connection pooling within Database server i have the
value set to 0 ( for unlimited timeout).

The actual query I use is used to fill a dataset which is
the source for a crystal report.

Any advice would be very welcome.

Jarrad

[Atrax]

> when put a large query through

> the server

define 'large query'?




________________________________________
Atrax. MVP, IIS
[url]http://rtfm.atrax.co.uk/[/url]

newsflash : Atrax.Richedit 1.0 now released.
[url]http://rtfm.atrax.co.uk/infinitemonkeys/components/Atrax.RichEdit/[/url]

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Jazza P]

The query cycles through a database table that is about 3Gig in Size,
with a key index on four fields.

The actual query takes up to 3-5 minutes to run.



Until it you try it, you don't know it doesn't work

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!