frontpage pivot table

[crunch]

I have a big problem about determining connection timeout period of pivot
table
at frontpage...Since my queries are heavy,default connection timeout period
is not sufficent for me...and I always receive a error message like 'Timeout
expired'..How can I change this connection time period?Anyone can help me??

 

[Stefan B Rusynko]

See http://www.aspfaq.com/show.asp?id=2066
- but I agree w/ the article that increasing the timeout is masking a bigger problem (inefficient code)




|I have a big problem about determining connection timeout period of pivot
| table
| at frontpage...Since my queries are heavy,default connection timeout period
| is not sufficent for me...and I always receive a error message like 'Timeout
| expired'..How can I change this connection time period?Anyone can help me??

 

[crunch]

I agree but I donot know how to embed this code into the pivot table code
since pivot tabel code begins with 'connectionstring...........' I know how
to cope with connection timeout in asp code but I do not know where to put
the CONNECTION TIMEOUT code inside the pivot table..can you help me?

"Stefan B Rusynko":