Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
I am trying to connect to MySQL database from a SSIS package. I am using .NET provider for MySQL Data provider connection type to connect to MySQL.
I have been facing the timeout issue error.
Issue:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
I tried to add below connection attributes to connection string, but still it is failing.
server=<servername>;user id=<userid>;port=3306;database=<database> ;persistsecurityinfo=True;connect timeout = 3600;Allow Batch = true;Pooling= true;default command timeout=200;
Please help. I appreciate your response.
Subject
Written By
Posted
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
August 04, 2014 01:39AM
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.