On Sun, Jan 5, 2014 at 8:31 PM, cedriz monteagudo <dice_in_trouble@...> wrote:

 

Hello Mark,

Thank you for the reply. We are currently using a application developed on Delphi. Now as the company grows, we are thinking of hosting the database so that we can access it from branch to branch. However we are not familiar with this setup, as I have asked if ever we hosted the database will we still able to use our current application or should we resort to a web based one. And also, about VPNs, we do not have an idea about that. What runs on our head at the moment is that we host the database and connect through it using our application (like we did on lan) and do the same on other branches. Also do we still need to use VPN if ever we host the database somewhere else?

Thanks,

Using VPN, you put your database in a server that will be accessible on any computer connected via VPN. it will have access to your database as if it is in your LAN. So i would suggest you to consider using VPN instead hosting it on web hosting for security and privacy reason. Put your database server on a LAN that have access the database mostly, usually it is on the head office.

You should consider upgrade it to the latest delphi XE5 to take the advantage of the latest Datasnap technology that will help you more on solving your multiple distance branch location problem. With datasnap, you will only need to have one server to access the database, all other client will communicating with this server application. In short, it is like a web server in delphi. You can access them using TCP or HTTP/HTTPS, if you are using TCP, you need VPN for security, otherwise you can use HTTPS for more secure protocol.

 

--
Iwan Cahyadi Sugeng

Interaktif Cipta Lestari