Server timeout

[terricide]

Is there a limit to the amount of data you can have in a data source when previewing in the web designer?

I had a query that returned 23,000 rows and I keep getting server timeout. If I choose different dates with less data then I don't get the timeout.

I've changed the command-timeout in the datasource to 600 and changed the ServerTimeout of the webdesigner control to 1 hour.

Any ideas?

[Alex K.]

Hello,

Try to set the CommandTimeout property for datasource.

Thank you.

[terricide]

Yeah I did that. It didn't make a difference.

[Alex K.]

Hello,

Try to set the following property:
StiWebViewerFxOptions.Connection.ClientRequestTimeout = 60; (in seconds)

Thank you.

[terricide]

That seemed to help. Thanks

[Andrew]

Hello,

Great!

Let us know if you need any help in this regard.
Thank you.