Joshua Brown
|
| Posted: 11/13/2002, 1:37 PM |
|
I am using an SQL Select Statement for the Data behind my Grid. But, my
query is taking more than the allotted 30 second time limit to load... How
do I extend the 30 seconds to 600 Seconds?
The actual error I'm getting is:
Error: Timeout expired (Microsoft OLE DB Provider for SQL Server.
|
|
|
 |
FLhr
|
| Posted: 11/13/2002, 8:08 PM |
|
Do you really want to give the query 10 minutes to run?
"Joshua Brown" <josh@atclubs.com> wrote in message
news:aqugng$ofp$1@news.codecharge.com...
> I am using an SQL Select Statement for the Data behind my Grid. But, my
> query is taking more than the allotted 30 second time limit to load... How
> do I extend the 30 seconds to 600 Seconds?
>
> The actual error I'm getting is:
> Error: Timeout expired (Microsoft OLE DB Provider for SQL Server.
>
>
|
|
|
|
Joshua Brown
|
| Posted: 11/14/2002, 5:09 AM |
|
Yes, I really want to allow it to run for 10 minutes? Any suggestions?
"FLhr" <flhr2003@yahoo.com> wrote in message
news:aqv7kc$pk$1@news.codecharge.com...
> Do you really want to give the query 10 minutes to run?
>
> "Joshua Brown" <josh@atclubs.com> wrote in message
>news:aqugng$ofp$1@news.codecharge.com...
> > I am using an SQL Select Statement for the Data behind my Grid. But, my
> > query is taking more than the allotted 30 second time limit to load...
How
> > do I extend the 30 seconds to 600 Seconds?
> >
> > The actual error I'm getting is:
> > Error: Timeout expired (Microsoft OLE DB Provider for SQL Server.
> >
> >
>
>
|
|
|
|
FLhr
|
| Posted: 11/14/2002, 7:46 PM |
|
First I would try to use an indexed field (if possible) for the query.
The connection timeout is set on your Web Server.
flhr
"Joshua Brown" <josh@atclubs.com> wrote in message
news:ar079n$nsq$1@news.codecharge.com...
> Yes, I really want to allow it to run for 10 minutes? Any suggestions?
>
|
|
|
|
