Re: Restrict internet access using ODBC?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

"JamesB" <JamesB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:70B7E91C-D5DA-46ED-82DB-5F5CB467F47B@xxxxxxxxxxxxxxxx
I was wondering if it was possible to remove internet access from a PC but,
still run tracsactions over the internet using our software program which is
connected the an internet accessable sql server via odbc? Our SQL sales
program processes credit and gift cards, because of this all of the PCs have
had internet access. Will OBDC still act as a "proxy" for us for internet
access instead of having to have the PC "on the internet"?


Hi James,

I'm not an expert in this area but...

When you say you want to "remove internet access" do you mean that you want to prevent users from using browsers or email? In order to communicate with the offsite SQL Server you'll need "internet access" but you may be able to block some outgoing and incoming ports, restricting the internet access to your application.

--
Cindy Winegarden
cindy@xxxxxxxxxxxxxxxxxxx

VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx

.

Relevant Pages

  • Re: Best Pratice-Remore ADO Access
    ... > end app will be installed on clients and the SQL Server ... > use the Internet to move data back and forth. ... >> data over a WAN connection to a SQL Server. ... >> INSERT clause would be the most efficient method, ...
    (microsoft.public.vb.database.ado)
  • Re: remoting vs. direct sql connection
    ... I'd say that you should never expose your SQL Server directly to the ... Internet -- the security risks are simply far too great. ... Using either a web service or remoting will also somewhat help in relieving ... Remoting logically uses a connection per ...
    (microsoft.public.dotnet.framework.remoting)
  • Re: SQL CE Setup 101... C#
    ... the Internet Url. ... We have seen issues when we give IP address in internet ... Try using the sql server instance name. ... > // Create the Local SSCE Database subscription. ...
    (microsoft.public.sqlserver.ce)
  • Re: MDB vs ADP
    ... So whilst in many cases it can be very slow using an adp / mdb to connect to ... a sql server over the net you can make it work. ... > MDB and ADP over the Internet; not only when loading 1000 records but also ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Restrict internet access using ODBC?
    ... SQL Server is accessed over the local area network (LAN), not the Internet. ... You can also setup LANs that are separate from those that have Internet access and prevent port access between the LANs that would permit outside access. ...
    (microsoft.public.sqlserver.connect)