Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How SAFE is FoxPro & SQL
Message
From
01/12/2006 02:20:52
 
 
To
30/11/2006 21:18:04
Joel Hokanson
Services Integration Group
Bellaire, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01173969
Message ID:
01174013
Views:
12
>How safe is a FoxPro system (desktop) that uses an SQL database at a remote site through ODBC over the Internet?
>
>Can data be intercepted and easily read by unauthorized people?
>
>I know the truth is that there I so much data going over the Internet that there is safety just in the fact that no one would bother to try to trap MY data. However Clients always think that some criminal will spend thousands of dollars to find out who my Client sold their last case of toilet paper to. NOT Likely, but possible.
>
>How safe is SQL data?

As usual, the answer is "it depends".

Before the remote client can communicate with the SQL server (via an ODBC connection), first a network connection has to be established. Often, this is done by creating a "virtual private network" (VPN - see Wikipedia for an overview). If your network people have set up a VPN between the two endpoints then any traffic carried through that VPN is transparently encrypted/decrypted with pretty good algorithms, so you don't need to worry about anyone in the middle sniffing the data stream.

Come to think of it, just about all modern technologies used to establish persistent connections through the Internet are very security-conscious so it's actually unlikely that a non-encrypting technology is being used. Nevertheless, it's a good question and one well worth asking of your network people.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Reply
Map
View

Click here to load this message in the networking platform