Can a poor client VPN connection corrupt a database?

[KurskKnyaz]

We have a small office with one server and one client that connects to the server’s database for the Sage 300 accounting software. The server is also being used as a workstation for the Sage 300 software. I want the person who uses the server was a workstation to be able to connect to the server from home so I figured the best way to do this would be to install the Sage 300 client software on the home computer, connect the computer to the office via VPN and then open the database that is on the server in the Sage 300 client software.

According to the Sage technical support staff, this is not recommended because VPN connections are unreliable and can lead to data corruption on the database if there is a problem with the VPN connection.

How true is this? I figured that since PPTP uses TCP there should be no data corruption. Am I wrong about this?

What is the best way to connect to the server remotely without risking data corruption if the VPN fails? I was thinking that the computer from home can connect to the SonicWall router through VPN and then connect to the server through remote desktop in which case no data will actually be stored on the client computer at home. Please advise. Thanks.

 

[mxnerd]

If a database app is designed to run on a LAN, then yes, a slow VPN can absolutely corrupt a database.

The best way is to remote into the PC. Use Windows RDP, Teamviewer or other remote control program are way better. All the data transactions happen at corporate network, yet only screen, mouse & keyboard are transmitted over remote control connection, not corporate database data.

Don't use database client on a VPN connection, it makes database data being transmitted back and forth on a slow VPN, which causes data corruption.

 

[sdifox]

first of all, stop using pptp.
second, have a pc at work used solely for remote access. then use teamviewer or something to connect to it, run the sage client in that machine. that way even if you lose remote link, you are not breaking the sage link.

or what mxnerd saig

 

[John Connor]

Never use PPTP as what was suggested. It is hackable. RDP or Teamviewer would be best, as suggested.

You do make backups?

Actually, I would in fact use Teamviewer. It is HIPAA approved and uses AES encryption. I have an App in Linux that can crack RDP. So... yeah.

https://www.teamviewer.com/en/index.aspx