[help] VB application SQL Server connection
hello all, i am developing a small management software on vb.net ... i wanna connect it to a small server running Windows Server 2008, and SQL Server 2008.
the main office (which has the server in it) is on the same network with the Server, so i have no problem with that !!
the other 2 branches are in 2 different locations.
What are my options to connect these other 2 branches, and what is my best approach to do it !!??
if anyone could advice me, i'd appreciate ur help !!
Thanks in advance.
Re: [help] VB application SQL Server connection
If clients at the other offices can VPN into the network at the server location then you should, configuration permitting, be able to connect to the database directly as though you were on the same network. Otherwise, you could publish a web service on the same network as the database and then have clients connect to that, with it performing the data access.