ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   PivotTable CommandTimeout (https://www.excelbanter.com/excel-programming/387799-pivottable-commandtimeout.html)

shaunmckeag

PivotTable CommandTimeout
 

I use frontpage 2003 to generate XML code for PivotTables and then copy the
XML into an ASP.NET page. Everything works fine unless the query takes more
than 30 seconds to complete. How can I change the XML to have a
CommandTimeout of more than 30 seconds? I've tried putting a CommandTimeout
property in the ConnectionString but it has not worked.

Thank you.

--
Sincerely,

Shaun McKeag


All times are GMT +1. The time now is 04:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com