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