Page 1 of 1
Query timeout expired Error, Please help me!
Posted: Thu Dec 15, 2011 12:00 am
by hanntd
Dear,
I use Designer to create and test my report now I facing a problem of Query timeout expired.
I have changed timeout connection in SQL Server to zero and also change the timeout in connection string in Designer but the error still happen.
Please help me!
Thanks
Han
Query timeout expired Error, Please help me!
Posted: Thu Dec 15, 2011 8:25 am
by Alex K.
Hello,
You need set the CommandTimeout property for DataSource.
Thank you.
Query timeout expired Error, Please help me!
Posted: Thu Dec 15, 2011 10:44 am
by hanntd
Dear Aleksey,
I can't find the property Connection Timeout as you said.
Thanks
Han
Query timeout expired Error, Please help me!
Posted: Thu Dec 15, 2011 11:03 am
by hanntd
I found it and it worked.
Can we set this value in .NET code so that developer no need to change in every reports.
Thanks Aleksey a lot.
Han
Query timeout expired Error, Please help me!
Posted: Fri Dec 16, 2011 6:50 am
by HighAley
Hello, Han.
hanntd wrote:I found it and it worked.
Can we set this value in .NET code so that developer no need to change in every reports.
Please, use next code:
Code: Select all
((StiSqlSource)report.Dictionary.DataSources["SqlSourceName"]).CommandTimeout = 6000;
Thank you.
Query timeout expired Error, Please help me!
Posted: Fri Dec 16, 2011 11:27 am
by hanntd
It worked like a charm!
Thanks you so much
Han
Query timeout expired Error, Please help me!
Posted: Mon Dec 19, 2011 7:01 am
by Andrew
Hello,
Great!
Re: Query timeout expired Error, Please help me!
Posted: Tue Apr 10, 2018 8:02 pm
by Tester123
Hello,
This feature seems to have been moved, where can i find it now?
Re: Query timeout expired Error, Please help me!
Posted: Thu Apr 12, 2018 2:23 am
by Edward
Hi Tester,
The 'Command Timeout' property is still there, its location has not changed really. Please follow the easiest way to find it in my opinion:
1) Create a SQL-based DataConnection in the Dictionary and then add a DataSource to that DataConnection.
2) Right-click on the DataSource and select Properties to access the Command Timeout property of that DataSource.
- Timeout.png (30.87 KiB) Viewed 8506 times
Thank you,
Edward