I am really in a big trouble...pls help me about connection timeou

[Guest]

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 <xrovider=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

 

[Stefan B Rusynko]

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

--




|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 <xrovider=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