Timeout Expired

[mmurdock]

I'm getting the following error when running a query that takes longer then 30 seconds.

"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

I am using 2008.1 and I am connecting to a mySQL database using the connector from this post: http://forum.stimulsoft.com/Default.aspx?g=posts&t=1314

I am using version 5.2.1 of the mysql.net connector.

This also happens when using 2007.3 and an older version of the mysql.net connector and your previous version of the mysql connector pack.

After a bit of research I think that mysql's CommandTimeout option defaults to 30 seconds. I think that this either needs to be set to 0 for unlimited or something higher to allow for longer queries, however I think this change needs to be done in the connector pack.

Thanks,

Mat

[Edward]

Hello, Mat.

Please download the new version of the MySQL DataBase pack for MySQLConnector.Net

Also here is the pack for CoreLab users too

Thank you.

[mmurdock]

So I get the following error after the query runs for 30 seconds. If I set this option, StiReport1.HideExceptions = True, in my program then I get a blank page after the program runs for a while. Thanks again for helping me with this.

[Edward]

Hello, Mat.

Please select the DataSource then press F4 or switch to Property Editor and increase value of CommandTimeout property of the DataSources as required.

Thank you.

[mmurdock]

That worked! Thanks for fixing this!!

Mat

[Edward]

Hello, Mat.

Please let us know if you need any help.

Thank you.

[iam]

where is location datasource??
please help me.
newbie..

[Alex K.]

Hello,

The data sources are located in the tab Dictionary in the property grid.

Thank you.

[iam]

i have resolved this problem by indexing database.
thank you

[Andrew]

Hello,

Great!

Have a nice weekend!