Harvey West
18th January 2007, 18:10
My program does a lot of transactions with a mysql database over short space of time. Server/Client hosts our XP.
After a while the connections start to fail with
DB open failed: QSqlError(2003, ""QMYSQL: Unable to connect"", ""Can't connect to MySQL server on 'localhost' (10048)"")
My hunch is the QSqlDatabase::close() connections take some time to complete.
"time to live" connection close time setting may fix this. But can't find.
I've looked in Mysql global settinggs / Tcpip registrys.
Has any one seen this before and know of a fix. Don't want to keep restarting the mysql service.
After a while the connections start to fail with
DB open failed: QSqlError(2003, ""QMYSQL: Unable to connect"", ""Can't connect to MySQL server on 'localhost' (10048)"")
My hunch is the QSqlDatabase::close() connections take some time to complete.
"time to live" connection close time setting may fix this. But can't find.
I've looked in Mysql global settinggs / Tcpip registrys.
Has any one seen this before and know of a fix. Don't want to keep restarting the mysql service.