Query timeout expired Error, Please help me!

Stimulsoft Ultimate discussion
Post Reply
hanntd
Posts: 11
Joined: Wed Dec 14, 2011 11:53 pm
Location: hcm

Query timeout expired Error, Please help me!

Post 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
Attachments
1503.err1.png
1503.err1.png (42.83 KiB) Viewed 8824 times
1502.connection.png
1502.connection.png (22.26 KiB) Viewed 8824 times
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Query timeout expired Error, Please help me!

Post by Alex K. »

Hello,

You need set the CommandTimeout property for DataSource.

Thank you.
Attachments
1506.1.PNG
1506.1.PNG (14.58 KiB) Viewed 8813 times
hanntd
Posts: 11
Joined: Wed Dec 14, 2011 11:53 pm
Location: hcm

Query timeout expired Error, Please help me!

Post by hanntd »

Dear Aleksey,
I can't find the property Connection Timeout as you said.
Thanks
Han
Attachments
1508.Data_prop.png
1508.Data_prop.png (30.12 KiB) Viewed 8808 times
hanntd
Posts: 11
Joined: Wed Dec 14, 2011 11:53 pm
Location: hcm

Query timeout expired Error, Please help me!

Post 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
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Query timeout expired Error, Please help me!

Post 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.
hanntd
Posts: 11
Joined: Wed Dec 14, 2011 11:53 pm
Location: hcm

Query timeout expired Error, Please help me!

Post by hanntd »

It worked like a charm!
Thanks you so much
Han
Andrew
Posts: 4104
Joined: Fri Jun 09, 2006 3:58 am

Query timeout expired Error, Please help me!

Post by Andrew »

Hello,

Great!
Tester123
Posts: 1
Joined: Tue Apr 10, 2018 7:58 pm

Re: Query timeout expired Error, Please help me!

Post by Tester123 »

Hello,

This feature seems to have been moved, where can i find it now?
Edward
Posts: 2913
Joined: Fri Jun 09, 2006 4:02 am

Re: Query timeout expired Error, Please help me!

Post 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
Timeout.png (30.87 KiB) Viewed 6154 times
Thank you,
Edward
Post Reply