timeout using .Net MySql Provider
Posted by:
ken janda
Date: October 16, 2012 09:52AM
I'm a SQL Server DBA that just inherited a MySql database. I have no previous experience with MySql.
I have a SQL Server SSIS package that connects to a MySql database using the .Net MySql Provider. I have the default command timeout set to 60 on the SSIS connection. However, the query is timing out after 30 seconds. i checked all MySql system variables for values of 30 to see what might be causing the timeout. i found the net_read_timeout set to 30 and the net_write_timeout set to 60. I have updated the net_read_timeout to 60 but I still get the timeout.
any ideas what might be causing the timeout?
thanks in advance.
Subject
Written By
Posted
timeout using .Net MySql Provider
October 16, 2012 09:52AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.