SalesPartner Real Estate Software
p +6444711849
  • News
  • Home
  • Software
    • SalesPartner Cloud
    • Websites
  • Pricing
  • Downloads
  • Contact us
  • Log in

Solved: idle SQL server connection dropping

30/7/2020

0 Comments

 
When using a multi tenant environment such as MariaDB, you could potentially see the error below if you left a workstation running overnight with SalesPartner open - particularly where you have hibernating computers or PCs that are left on standby / sleep.
[FireDAC][Phys][MySQL] MySQL server has gone away.
The solution is to add these two extra AutoReconnect options in the MariaDB connection definition via
C:\spartner\FDConnectionDefs.ini
Using Notepad to edit the INI file copy and paste this text.
ResourceOptions.AssignedValues= [rvAutoReconnect]
ResourceOptions.AutoReconnect= True
Picture
Then save the INI file and restart SalesPartner to apply changes.
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    AnyDesk Windows Link
    AnyDesk Mac Link
    Log in

    Admin
    Geoff Duncan

    Archives

    October 2021
    September 2021
    August 2021
    July 2021
    June 2021
    May 2021
    April 2021
    March 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    March 2014
    February 2014
    January 2014
    December 2013
    November 2013
    October 2013
    September 2013
    August 2013

    Categories

    All

    RSS Feed

Picture
"SalesPartner helps me extract maximum value from my
biggest asset - my database".

Andrew Duncan
www.agentmonday.com


Picture
Developed in Wellington, New Zealand
SalesPartner Software - established in 1993
Leading-edge software for real estate salespeople