C
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'.
frontpage pivot table begins with <xrovider=SQLOLEDB.1;Persist Security
Info=True;User ID=GoldmineASP;Initial Catalog=GMRMOP01;Data
Source=trbeucmd01;Extended Properties="remote query timeout=9999;command
timeout=500";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>
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
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="remote query timeout=9999;command
timeout=500";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>
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