Page 1 of 1

Timeout Expired

Posted: Fri Jun 20, 2008 12:16 pm
by 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

Timeout Expired

Posted: Mon Jun 23, 2008 1:30 pm
by 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.

Timeout Expired

Posted: Mon Jun 23, 2008 3:39 pm
by 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.



Image

Timeout Expired

Posted: Mon Jun 23, 2008 4:06 pm
by 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.

Timeout Expired

Posted: Mon Jun 23, 2008 4:57 pm
by mmurdock
That worked! Thanks for fixing this!!

Mat

Timeout Expired

Posted: Mon Jun 23, 2008 11:30 pm
by Edward
Hello, Mat.

Please let us know if you need any help.

Thank you.

Re: Timeout Expired

Posted: Fri Jul 12, 2013 9:57 am
by iam
where is location datasource??
please help me.
newbie..

Re: Timeout Expired

Posted: Fri Jul 12, 2013 12:11 pm
by Alex K.
Hello,

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

Thank you.

Re: Timeout Expired

Posted: Sat Jul 13, 2013 8:28 am
by iam
i have resolved this problem by indexing database.
thank you

Re: Timeout Expired

Posted: Sat Jul 13, 2013 4:49 pm
by Andrew
Hello,

Great!

Have a nice weekend!