Query timeout expired Error, Please help me!
Query timeout expired Error, Please help me!
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
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 (42.83 KiB) Viewed 8824 times
-
- 1502.connection.png (22.26 KiB) Viewed 8824 times
Query timeout expired Error, Please help me!
Hello,
You need set the CommandTimeout property for DataSource.
Thank you.
You need set the CommandTimeout property for DataSource.
Thank you.
- Attachments
-
- 1506.1.PNG (14.58 KiB) Viewed 8813 times
Query timeout expired Error, Please help me!
Dear Aleksey,
I can't find the property Connection Timeout as you said.
Thanks
Han
I can't find the property Connection Timeout as you said.
Thanks
Han
- Attachments
-
- 1508.Data_prop.png (30.12 KiB) Viewed 8808 times
Query timeout expired Error, Please help me!
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
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!
Hello, Han.
Thank you.
Please, use next code: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.
Code: Select all
((StiSqlSource)report.Dictionary.DataSources["SqlSourceName"]).CommandTimeout = 6000;
Query timeout expired Error, Please help me!
It worked like a charm!
Thanks you so much
Han
Thanks you so much
Han
Query timeout expired Error, Please help me!
Hello,
Great!
Great!
Re: Query timeout expired Error, Please help me!
Hello,
This feature seems to have been moved, where can i find it now?
This feature seems to have been moved, where can i find it now?
Re: Query timeout expired Error, Please help me!
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.
Thank you,
Edward
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.
Thank you,
Edward