In ordinary ADO, you would increase the CommandTimout value on the
database Connection or Command object.
Take at look at the equivalent in .NET. Search for CommandTimeout in the
framework help and adjust your value accordingly. Default is 30 seconds.
Dave
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_009E_01C165F6.2C783480
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Does anybody know how I can fix the following problem on my ASPX page:
> "Timeout expired. Possible reasons: the timeout period elapsed prior to
> completion of the operation, the server is not responding, or the
> maximum pool size was exceeded. Please see the documentation for further
> details."
>
> It looks like it is timing out because I am running a SP which takes
> about 40 sec to run.
>
> Thanks
> Ricky
>
> ------=_NextPart_000_009E_01C165F6.2C783480
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META http-equiv=3DContent-Type content=3D"text/html;
> charset=3Diso-8859-1">
> <META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT face=3DArial size=3D2>
> <DIV><FONT face=3DArial size=3D2>Does anybody know how I can fix the
> following
> problem on my ASPX page:</FONT></DIV>
> <DIV><FONT face=3DArial color=3D#ff0000 size=3D2><STRONG>"Timeout
> expired. Possible
> reasons: the timeout period elapsed prior to completion of the
> operation, the
> server is not responding, or the maximum pool size was exceeded. Please
> see the
> documentation for further details."</STRONG></FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV><FONT face=3DArial size=3D2>It looks like it is timing out because
> I am running
> a SP which takes about 40 sec to run.</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV>
> <DIV><FONT face=3DArial
> size=3D2>Ricky</FONT></DIV></FONT></DIV></BODY></HTML>
>
> ------=_NextPart_000_009E_01C165F6.2C783480--