SQL Server is accessed (in this case) over the local area network (LAN), not
the Internet. It uses different ports than the browsers. I suggest you
simply disconnect the LAN from the Internet. Of course, this means no one
can use the Internet for legitimate access like corporate email, setting up
travel reservations or checking on the current activity of Paris Hilton. 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.
--
____________________________________
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)
-----------------------------------------------------------------------------------------------------------------------
[quoted text, click to view] "JamesB" <JamesB@discussions.microsoft.com> wrote in message
news:53EED798-0059-483B-85AD-08907B30E59A@microsoft.com...
> I'm sorry if I was not totally clear. The SQL box is on the same physical
> lan as the PCs. Yes, I am trying to remove internet access (i.e. E-mail,
> chat, browsing, etc.)
>
> "Cindy Winegarden" wrote:
>
>> "JamesB" <JamesB@discussions.microsoft.com> wrote in message
>> news:70B7E91C-D5DA-46ED-82DB-5F5CB467F47B@microsoft.com...
>> >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@cindywinegarden.com
>>
>> VFP OLE DB:
http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx >> VFP ODBC:
http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx >>
>>
