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'.
frontpage pivot table begins with <x:Provider=SQLOLEDB.1;Persist Security
Info=True;User ID=GoldmineASP;Initial Catalog=GMRMOP01;Data
Source=trbeucmd01;Extended Properties=&quot;remote query timeout=9999;command
timeout=500&quot;;Use Procedure for Prepare=1;Auto Translate=True;Packet
Size=4096;Workstation ID=TRCAL022;Use Encryption for Data=False;Tag with
column collation when possible=False</x:ConnectionString&gt

I added command timeout and connect timeout commands but it does not
work....I added every thing I know......
I will be very very very very appreciated if you help me urgently...I am in
real trouble...
I have been on this troubles for two days

Sounds more like a SQL server timeout issue
See if any of these help
http://support.microsoft.com/search/...=sup&x=10&y=16

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


"crunch" <(E-Mail Removed)> wrote in message news:1E64D791-A544-4DD0-B8D6-(E-Mail Removed)...
|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'.
| frontpage pivot table begins with <x:Provider=SQLOLEDB.1;Persist Security
| Info=True;User ID=GoldmineASP;Initial Catalog=GMRMOP01;Data
| Source=trbeucmd01;Extended Properties=&quot;remote query timeout=9999;command
| timeout=500&quot;;Use Procedure for Prepare=1;Auto Translate=True;Packet
| Size=4096;Workstation ID=TRCAL022;Use Encryption for Data=False;Tag with
| column collation when possible=False</x:ConnectionString&gt
|
| I added command timeout and connect timeout commands but it does not
| work....I added every thing I know......
| I will be very very very very appreciated if you help me urgently...I am in
| real trouble...
| I have been on this troubles for two days