Re: accessing remote database

thanks William,
yes, most of the clients are in LAN and few remote users are on WAN and
connect through VPN.
My manager argues that accesing through Web Service is more secure because
clients don't have connection string embeded in application. What is your
opinion on that?



"William Vaughn" <billvaNoSPAM@xxxxxxxxx> wrote in message
news:%23RTgJk$FIHA.5228@xxxxxxxxxxxxxxxxxxxxxxx
It depends whether it's on a LAN or a WAN. If it's a LAN use
direct-connect. On a WAN use an ASP.NET application to front it or better
yet, a direct-connect via VPN connection.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no
rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Andy" <kc2ine@xxxxxxxxx> wrote in message
news:ecXoFG2FIHA.284@xxxxxxxxxxxxxxxxxxxxxxx
Hi,
What is the best approach for a application havily using remote database
to connect to?
Somebody suggested Web service, but isn't that slow and to big overhead
for such application?





.

Relevant Pages

  • Re: NetGear FVS124G
    ... Manageable DUAL WAN VPN Firewall with Gigabit LAN Ports ... support, and up to 25 IPSec VPN tunnels assures safe network computing. ...
    (comp.security.firewalls)
  • Re: Outlook
    ... Outlook, and you'd have the centralized configuration, backup, management, ... and other benefits of Exchange. ... Then remote users would have two options, OWA, or Outlook using RPC over ... By the way, on the topic of VPN, depending on your circumstances I'd almost ...
    (microsoft.public.windows.server.sbs)
  • Re: VPN shares..... again
    ... browser on the remote computer (no VPN required). ... This feature is available in both versions of SBS ... A VPN can be painfully slow for remote users ...
    (microsoft.public.windows.server.sbs)
  • Re: How to share a file between remote users?
    ... Real data has to be shoved from one end of the VPN ... SBS 2003 can't run TS in Application mode so you can't use SBS as a Terminal ... Server itself. ... if the remote users can schedule access times to the QB ...
    (microsoft.public.windows.server.sbs)
  • Re: Network NeighbourHood problem
    ... log in directly into the domain, without the need of VPN) An Microsoft ... remote users do not appear in network neighbourhood on the server.. ... We have yet to set the backup to occur on the remote users computers ...
    (microsoft.public.windows.server.sbs)
Loading