My Connection broke down very often RRS feed

  • Question

  • Hi,

    I am using MS-Excel 2013 with Power Querry 2.1 , I ma having an operating system Windows 8.1 (64 bit) and I am using the MySQL connector (mysql-connector-net-6.7.5) 

    My problem is I am able to connect to a MySQL database after providing the credentials but after an interval of time (5-10 mins of idle situation) the connection broke down and I have to connect to my DB again and again.... if the process happened at the back-end then it's okay but the excel seems to be crashed and I have to connect everything again 

    Is there some solution for this issue..

    looking forward to hear back some positive results

    Thanks and regards

    Tuesday, December 2, 2014 12:46 PM