Devart Forums

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 using isql:

[0800][unixODBC][Devart][ODBC][Microsfot SQL Server] Error on data reading from the connection:
Try Again.

The second time I try it works fine.

Its seems that either Ubuntu or vSphere is causing a HUGE latency issue on the LAN after a minute or so of idle time. To fix this, I created a CRON job on my Ubuntu server that starts when the server is booted. This job basically pings an IP address every 30 second to keeps the connection alive....

/bin/ping -i 30 xxx.xxx.xxx.xxx

where xxx.xxx.xxx.xxx is some device that responds to a ping.

Do you manage to establish a test connection when using our driver in your system? Or is the problem related to a large length of delay when working in the virtual environment?