Intermintant connection issue
Posted: Mon 13 Mar 2017 18:12
SYSTEM: PHP 7, UnixODBC, Ubuntu 16.04 virtualized on VM using Vsphere 6
When attempting a connection after a significant amount of idle time between requests, I get the following error:
odbc_connect(): SQL error: [unixODBC][Devart][ODBC][Microsoft SQL Server]Error on data reading from the connection: Connection reset by peer. Socket Error Code: 104($68), SQL state 08001[unixODBC][Devart][ODBC][Microsoft SQL Server]Error on data reading from the connection: Connection reset by peer. Socket Error Code: 104($68) in SQLConnect
Anyone know who to fix this intermittent error? It seems to be directly related to how long between SQL requests... frequent requests are handled well... requests after a long delay... say minutes... usually result in the error.
This behavior is NOT seem on my non-virtualized dev system running Ubuntu 12.04 & PHP 5
When attempting a connection after a significant amount of idle time between requests, I get the following error:
odbc_connect(): SQL error: [unixODBC][Devart][ODBC][Microsoft SQL Server]Error on data reading from the connection: Connection reset by peer. Socket Error Code: 104($68), SQL state 08001[unixODBC][Devart][ODBC][Microsoft SQL Server]Error on data reading from the connection: Connection reset by peer. Socket Error Code: 104($68) in SQLConnect
Anyone know who to fix this intermittent error? It seems to be directly related to how long between SQL requests... frequent requests are handled well... requests after a long delay... say minutes... usually result in the error.
This behavior is NOT seem on my non-virtualized dev system running Ubuntu 12.04 & PHP 5